文件名称：获得约束信息-oracle基础讲义
文件大小：4.17MB
文件格式：PPT
更新时间：2024-05-12 07:16:07
orcle基础讲义
获得约束信息 查询下列视图获得关于约束的信息： DBA_CONSTRAINTS DBA_CONS_COLUMNS 举例： SQL> SELECT constraint_name, constraint_type, deferrable, 2 deferred, validated 3 FROM dba_constraints 4 WHERE owner='HR' 5 AND table_name='EMPLOYEES'; CONSTRAINT_NAME C DEFERRABLE DEFERRED VALIDATED ---------------- - --------------- ----------- ---------- EMPLOYEE_DEPT.. R DEFERRABLE DEFERRED VALIDATED EMPLOYEE_ID_PK P DEFERRABLE IMMEDIATE VALIDATED SYS_C00565 C NOT DEFERRABLE IMMEDIATE VALIDATED 3 rows selected.