查 CONSTRAINT
2013-08-06 15:10
SQL> set pages 5000
SQL> col owner for a10
SQL> select owner,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME from dba_constraints where OWNER='VOIP' order by 3,4,1
OWNER CONSTRAINT_NAME C TABLE_NAME
---------- ------------------------------ - ------------------------------
VOIP SYS_C004952 C CALL
VOIP SYS_C004951 C CALL
VOIP SYS_C004955 C CDR
VOIP SYS_C004957 C CDR
VOIP SYS_C004956 C CDR
VOIP SYS_C004954 C CDR
VOIP SYS_C004953 C CDR
VOIP SYS_C004958 C VOIPUSER
VOIP SYS_C004959 C VOIPUSER
VOIP SYS_C004960 C VOIPUSER
VOIP PK_CALL_ID P CALL
VOIP PK_VOIPUSER_ID P VOIPUSER
12 rows selected.