2013年(14)
发布时间: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-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.........【阅读全文】
发布时间:2013-08-17 18:11:37
设置一个反斜线作为转义字符. 它之后放置的任意字符除了给定一个特定含义以外 , 还当作一个直接量值. 要想让反斜线作为转义字符, 使用以下 SQL*PLUS 命令: SQL> show escapeescape OFFSQL> show definedefine "&" (hex 26)SQL> select 'a\&a' from dual;Enter value for a: 1old 1: select '.........【阅读全文】
发布时间:2013-08-15 16:15:15
with a as(select 'abcdeft' as a1 from dualunion allselect 'aaabbb' as a1 from dual)select regexp_replace(a.a1,'(...)(.+$)','\1123\2') from a; REGEXP_REPLACE(A.A1,'(...)(.+$-----------------.........【阅读全文】