SQL> select object_name from all_objects where object_name like '%CONSTRAINT%';
OBJECT_NAME
------------------------------
ALL_CONSTRAINTS
DBA_CONSTRAINTS
DBA_IAS_CONSTRAINT_EXP
LOADER_CONSTRAINT_INFO
USER_CONSTRAINTS
ALL_CONSTRAINTS
DBA_CONSTRAINTS
LOADER_CONSTRAINT_INFO
USER_CONSTRAINTS已选择9行。SQL> desc user_constraints
名称 空? 类型
---------------------------------------- -------- ---------------------------
OWNER NOT NULL VARCHAR2(30)
CONSTRAINT_NAME NOT NULL VARCHAR2(30)
CONSTRAINT_TYPE VARCHAR2(1)
TABLE_NAME NOT NULL VARCHAR2(30)
SEARCH_CONDITION LONG
R_OWNER VARCHAR2(30)
R_CONSTRAINT_NAME VARCHAR2(30)
DELETE_RULE VARCHAR2(9)
STATUS VARCHAR2(8)
DEFERRABLE VARCHAR2(14)
DEFERRED VARCHAR2(9)
VALIDATED VARCHAR2(13)
GENERATED VARCHAR2(14)
BAD VARCHAR2(3)
RELY VARCHAR2(4)
LAST_CHANGE DATESQL>
解决方案 »
- 急 oracle 备份多张表的问题
- 如何用一条sql语句去掉两个日期中的周末
- Oracle9例程不能打开。
- 同为oracle 10G的字符集为Simplified Chinese_china zhs16gbk的库如何移殖入字符集为utf8的库中
- 请问一个SQL查询的问题
- 关于oracle导dmp文件的参数问题!!!
- Oracle9i有多少个版本?我见怎么有三碟也有起碟的?我安装七碟版时对照DOC目录里的安装说明安装的,但复制完了却连接不上数据库,安装失
- order by效率问题
- 急急急:ORACLE73如何在WIN2000下正确安装,高分相送,不够可以再给。
- oracle里可以使用表变量吗?在线等待
- 为什么我访问数据库时,我见到数据库里面的中文都是乱码?
- 谁有TOAD的注册码?
SQL> select object_name from all_objects where object_name like '%CONS%';
OBJECT_NAME
------------------------------
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_IAS_CONSTRAINT_EXP
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
DEFAULT_CONSUMER_GROUP
GV_$RSRC_CONSUMER_GROUP
GV_$RSRC_CONSUME_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
RESOURCE_CONSUMER_GROUP$
SM$INTEGRITY_CONS
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V_$RSRC_CONSUMER_GROUP
V_$RSRC_CONSUMER_GROUP_CPU_MTH
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
GV$RSRC_CONSUMER_GROUP
GV$RSRC_CONSUMER_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH
/4373969e_CONST
/7e8ba6b6_CONSTFormatInfo
ORDIMAGECONSTANTS已选择37行。SQL> SQL> desc USER_CONS_COLUMNS
名称 空? 类型
---------------------------------------- -------- ---------------------------
OWNER NOT NULL VARCHAR2(30)
CONSTRAINT_NAME NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
POSITION NUMBERSQL>
SQL> select object_name from all_objects where object_name like '%CONS%';
OBJECT_NAME
------------------------------
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_IAS_CONSTRAINT_EXP
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
DEFAULT_CONSUMER_GROUP
GV_$RSRC_CONSUMER_GROUP
GV_$RSRC_CONSUME_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
RESOURCE_CONSUMER_GROUP$
SM$INTEGRITY_CONS
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V_$RSRC_CONSUMER_GROUP
V_$RSRC_CONSUMER_GROUP_CPU_MTH
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
GV$RSRC_CONSUMER_GROUP
GV$RSRC_CONSUMER_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH
/4373969e_CONST
/7e8ba6b6_CONSTFormatInfo
ORDIMAGECONSTANTS已选择37行。SQL> SQL> desc USER_CONS_COLUMNS
名称 空? 类型
---------------------------------------- -------- ---------------------------
OWNER NOT NULL VARCHAR2(30)
CONSTRAINT_NAME NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
POSITION NUMBERSQL>