做数据库作业写了个PL/SQL语句但是反复的不让通过,希望哪位高手给我看看哪错了,万分感谢
create or replace procedure P_STUADD
(v_Sno in number,
v_Sname in varchar2
,v_Sex in varchar2
,v_Age in number
,v_Spri in varchar2
,v_Domno in number
,v_Tname in varchar2
,v_Honor in varchar2
,v_Cno in number
,v_Sdpt in varchar2)
as
begin
if (v_Sno not in (select SNO from Student_grade))
then
INSERT INTO Student_grade(Sno)
VALUES(v_Sno);if( v_Cno not in (select CNO from Class_grade))
then
INSERT INTO Class_grade(Cno)
VALUES(v_Cno);if(v_Domno not in (select DNO from Dom_grade))
then
INSERT INTO Dom_grade (Dno)
VALUES(v_Dno);if(v_Domno not in (select Domno from Domitory))
then
INSERT INTO Domitory(Domno)
VALUES(v_Domno); if(v_Tname not in (select Tname from Teacher))
then
INSERT INTO Teacher(Tname,Sdpt)
VALUES(v_Tname,v_Sdpt);if (v_Cno not in (select CNO from Class))
then
INSERT INTO Class(Cno,Sdpt)
VALUES(v_Cno,v_Sdpt);end if;
INSERT INTO Student(Sno,Sname,Sex,Age,Spri,Domno,Tname,Honor,Cno)
VALUES(v_Sno,v_Sname,v_Sex,v_Age,v_Spri,v_Domno,v_Tname,v_Honor,v_Cno);
end P_STUADD;
/
Cno Domno Tname等都是别的表的主码,直接插不进去
create or replace procedure P_STUADD
(v_Sno in number,
v_Sname in varchar2
,v_Sex in varchar2
,v_Age in number
,v_Spri in varchar2
,v_Domno in number
,v_Tname in varchar2
,v_Honor in varchar2
,v_Cno in number
,v_Sdpt in varchar2)
as
begin
if (v_Sno not in (select SNO from Student_grade))
then
INSERT INTO Student_grade(Sno)
VALUES(v_Sno);if( v_Cno not in (select CNO from Class_grade))
then
INSERT INTO Class_grade(Cno)
VALUES(v_Cno);if(v_Domno not in (select DNO from Dom_grade))
then
INSERT INTO Dom_grade (Dno)
VALUES(v_Dno);if(v_Domno not in (select Domno from Domitory))
then
INSERT INTO Domitory(Domno)
VALUES(v_Domno); if(v_Tname not in (select Tname from Teacher))
then
INSERT INTO Teacher(Tname,Sdpt)
VALUES(v_Tname,v_Sdpt);if (v_Cno not in (select CNO from Class))
then
INSERT INTO Class(Cno,Sdpt)
VALUES(v_Cno,v_Sdpt);end if;
INSERT INTO Student(Sno,Sname,Sex,Age,Spri,Domno,Tname,Honor,Cno)
VALUES(v_Sno,v_Sname,v_Sex,v_Age,v_Spri,v_Domno,v_Tname,v_Honor,v_Cno);
end P_STUADD;
/
Cno Domno Tname等都是别的表的主码,直接插不进去
解决方案 »
- 一个表和多个表进行左连接的问题?? 在线等,急!!!!!!!!!! 没有分了 有好心人帮帮忙么?
- 到哪能找到oracle-timesten的帮助文档?
- 求CNOUG邀请码
- 求一个拼 select查询字符串的 把变量两端 加引号的函数(oracle)
- 在没有和服务器连接的oracle的客户端,怎样建立数据库??恳请赐教!!!
- 怎样最方便更新被外部引用的主码的码值!
- imp后许多存储过程需要编译!
- 如何方便快速的在两个数据库的表间导数据?
- 1000_2000分,只要回答的正确,可以分几次给,问题很多,来者不拒
- oracle安装问题
- FormFile上传ORACLE BLOB类型的问题
- 关于插入数据问题
...
END IF;
IF ... THEN
...
END IF;
IF ... THEN
...
END IF;
IF ... THEN
...
END IF;
IF ... THEN
...
END IF;
IF ... THEN
...
END IF;