为什么下面的Oracle语句一直报错说缺失右括号，表名以及属性均正确
createviewtest6_06asselecta.sidsid,namefrompub.studentawherenotexist((selectcidfrompu...
create view test6_06 as select a.sid sid,name from pub.student a
where not exist((select cid from pub.course where cid is not null )minus
(select b.cid cid from pub.student_course b,pub.course c
where a.sid =b.sid and b.cid=c.cid and b.score>=60 )) 展开
where not exist((select cid from pub.course where cid is not null )minus
(select b.cid cid from pub.student_course b,pub.course c
where a.sid =b.sid and b.cid=c.cid and b.score>=60 )) 展开
2个回答
展开全部
你试试我写的
create view test6_06 as select a.sid sid,name from pub.student a where not exists((select cid from pub.course where cid is not null )minus(select b.cid cid from pub.student_course b,pub.course c where a.sid =b.sid and b.cid=c.cid and b.score>=60 ))
create view test6_06 as select a.sid sid,name from pub.student a where not exists((select cid from pub.course where cid is not null )minus(select b.cid cid from pub.student_course b,pub.course c where a.sid =b.sid and b.cid=c.cid and b.score>=60 ))
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
exist改成exists
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
