Oracle 编程

显示全部楼层 · 2011-10-18 05:27:37

1、查询姓“李”的老师的个数；SELECT COUNT(Tno) FROM Teacher WHERE Tname LIKE '李%'2、查询学过“c001”并且也学过编号“c002”课程的同学的学号、姓名；SELECT Sno, SnameFROM StudentWHERE sno IN(SELECT sno
FROM (SELECT Sno FROM SC WHERE Cno = 'c001') t1
(SELECT Sno FROM SC WHERE Cno = 'c002') t2
WHERE t1.sno = t2.sno)3、查询学过“...

千问 · 2011-10-18 05:27:37

CREATE OR REPLACE PROCEDURE Remove_cinema ASBEGINDELETEFROM
cinemaWHERE
addtime < sysdate - 1/(24*60);END Remove_cinema;...