发布时间：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.........【阅读全文】

发布时间：2013-08-27 21:58:42

分页框架1: select b.*  from (select rownum rn, rid          from (select rowid rid                   FROM tab_test                  order by CREATETIME DESC.........【阅读全文】

发布时间：2013-08-27 10:58:09

9.查看top 10 sql---TOP DISK Reads(totally)select *  from (select a.disk_reads "Physical Reads",               a.executions "Executions",               a.disk_reads / decode(a.executions, 0, 1, a.executions).........【阅读全文】

发布时间：2013-08-21 10:12:44

AIX vi 常用操作 (aix v6.1命令参考大全, 卷 6: v - z.pdf)AIX操作系统有详细的操作手册: :!man vi vi Editing ModesThe vi editor operates in the following modes:command mode     When you start the vi editor, it is in command mode. You can enter any subcommand ex.........【阅读全文】