摘要:
在Oracle中执行动态SQL的几种方法 在一般的sql操作中,sql语句基本上都是固定的,如:SELECT t.empno,t.ename FROM scott.emp t WHERE t.deptno = 20;但有的时候,从应用的需要或程序的编写出发,都可能需要用到动态SQl,如:当 from 阅读全文
摘要:
38 select s.sname,to_char(sysdate,'yyyy')-to_char(s.sbirthday,'yyyy') from student s where s.sbirthday is not null 39 select max(to_char(s.sbirthday,' 阅读全文
摘要:
25 select s.sno,s.sname,s.ssex,s.sbirthday,s.class,t.cno,t.degree from student s inner join score t on s.sno=t.sno order by sno,degree 26 select disti 阅读全文
摘要:
1 select t.sname,t.ssex,t.class from STUDENT t 2 select distinct(depart) from teacher t 3 select * from student 4 select * from score r where r.degree 阅读全文