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