2013年(14)
发布时间:2013-12-10 09:35:19
in 是确定集合select deptno, dname from dept where deptno in (10,20)/ DEPTNO DNAME---------- -------------- 10 ACCOUNTING 20 RESEARCHall 是查询还可以是子查询用于查询. 如: select.........【阅读全文】
发布时间:2013-08-28 00:26:34
Oracle 11g 以前的行列转换create table emp_phone (NAME varchar2(15), TYPES number, PHONE varchar2(15));insert into emp_phone values ('scott', 1, '1234-5678'); insert into emp_phone values ('scott', 2, '4567-7890');insert into emp_phone values ('scott', 3, '6000-1001');insert into emp_p.........【阅读全文】