数据库开发
crazy_samba
这个作者很懒,什么都没留下…
展开
-
Revoke oracle public privleges
1. Introduction of Oracle privilege A privilege is a right to execute an SQL statement or to access another user's object. Privilege mentioned in this bug is related with package objects. When dea原创 2013-02-05 08:19:11 · 1167 阅读 · 0 评论 -
How to enable AI(accent insensitiv) for one column without changing session
Following is my test SQL: create table accent_test(col varchar2(10 char); insert into accent_test values('INDIA'); insert into accent_test values('india'); insert into accent_test values('InDiÄ ')原创 2013-02-05 08:16:35 · 601 阅读 · 0 评论 -
Oracle trace & tkprof
NOTE1>: There are 3 methods to manage the SQL trace facility: a> oradebug -- execute it using sysdba by 'sqlplus / as sysdba' b> alter session -- you only need alter session privilege.原创 2013-02-05 08:25:33 · 492 阅读 · 0 评论