发布时间: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.........【阅读全文】
发布时间:2013-08-20 21:59:15
1, 查看所有用户select * from dba_user;select * from all_users;select * from user_users;2, 查看用户系统权限select * from dba_sys_privs;select * from all_sys_privs;select * from user_sys_privs;3, 查看用户对象权限select * from dba_tab_privs;select * from all_tab_privs;select * from.........【阅读全文】