2013年(14)
发布时间: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,'(...)(.+$-----------------.........【阅读全文】
发布时间:2013-08-04 16:37:28
SHOW PARAMETER 命令显示隐藏参数Find internal of "show parameter" by session tracingSQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterp.........【阅读全文】