Oracle DB 12.1.0.2 中SYS.ALL_CONSTRAINTS的定义 和 SYS.ALL_CONS_COLUMNS的定义
来源:互联网 发布:阿里妈妈淘宝客下载 编辑:程序博客网 时间:2024/06/08 17:17
SYS.ALL_CONSTRAINTS的定义如下:
CREATE OR REPLACE VIEW ALL_CONSTRAINTS ASselect OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, SEARCH_CONDITION, SEARCH_CONDITION_VC, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, DEFERRED, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME, INVALID, VIEW_RELATED, ORIGIN_CON_IDfrom INT$DBA_CONSTRAINTSwhere (OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER') or OBJ_ID(OWNER, TABLE_NAME, OBJECT_TYPE#, OBJECT_ID) in (select obj# from sys.objauth$ where grantee# in ( select kzsrorol from x$kzsro ) ) or /* user has system privileges */ exists (select null from v$enabledprivs where priv_number in (-45 /* LOCK ANY TABLE */, -47 /* SELECT ANY TABLE */, -397/* READ ANY TABLE */, -48 /* INSERT ANY TABLE */, -49 /* UPDATE ANY TABLE */, -50 /* DELETE ANY TABLE */) ) )
SYS.ALL_CONS_COLUMNS的定义如下:
CREATE OR REPLACE VIEW ALL_CONS_COLUMNS(owner, constraint_name, table_name, column_name, position)ASselect u.name, c.name, o.name, decode(ac.name, null, col.name, ac.name), cc.pos#from sys.user$ u, sys.con$ c, sys.col$ col, sys.ccol$ cc, sys.cdef$ cd, sys."_CURRENT_EDITION_OBJ" o, sys.attrcol$ acwhere c.owner# = u.user# and c.con# = cd.con# and (cd.type# < 14 or cd.type# > 17) /* don't include supplog cons */ and (cd.type# != 12) /* don't include log group cons */ and cd.con# = cc.con# and cc.obj# = col.obj# and cc.intcol# = col.intcol# and cc.obj# = o.obj# and (c.owner# = userenv('SCHEMAID') or cd.obj# in (select obj# from sys.objauth$ where grantee# in ( select kzsrorol from x$kzsro ) ) or /* user has system privileges */ exists (select null from v$enabledprivs where priv_number in (-45 /* LOCK ANY TABLE */, -47 /* SELECT ANY TABLE */, -397/* READ ANY TABLE */, -48 /* INSERT ANY TABLE */, -49 /* UPDATE ANY TABLE */, -50 /* DELETE ANY TABLE */) ) ) and col.obj# = ac.obj#(+) and col.intcol# = ac.intcol#(+)
0 0
- Oracle DB 12.1.0.2 中SYS.ALL_CONSTRAINTS的定义 和 SYS.ALL_CONS_COLUMNS的定义
- Oracle DB 11.2.0.4 中SYS.ALL_CONSTRAINTS的定义 和 SYS.ALL_CONS_COLUMNS的定义
- Oracle中sys和system的区别
- Oracle中sys和system的区别小结Oracle中sys和system的区别小结
- Oracle数据库中sys和system两个用户的区别
- Oracle中sys和system两个用户的区别
- Oracle数据库中sys和system两个用户的区别
- oracle中sys用户和system用户的区别
- oracle中sys和system的默认密码
- oracle中sys和system用户权限的区别
- oracle中sys和system的区别比较
- oracle中sys用户和system用户的区别
- Oracle数据库中system和sys的区别
- oracle中sys用户和system用户的区别
- Oracle中sys用户和system用户的区别
- oracle中sys用户和system用户的区别
- /sys/devices/ 下的设备name就是bios中定义的HID
- 关于udev,sys,proc,tmpfs一些定义的问题
- Android学习 AsyncTask
- 回首2014 展望2015
- android 通过webView上传文件给服务器(包括拍照)
- Java-泛型编程-类型擦除(Type Erasure)
- JAVA中的接口和抽象类(转)
- Oracle DB 12.1.0.2 中SYS.ALL_CONSTRAINTS的定义 和 SYS.ALL_CONS_COLUMNS的定义
- test
- Linux全网广播
- The Google File System 中文版论文(转载)
- spring延迟加载bean
- CentOS6.5 CentOS7 ssh免密码登录
- matlab车牌识别
- android编译报错问题
- (3) 查找算法 --- 顺序查找 折半查找