SET VERIFY OFF
set linesize 200
col owner format a15
col table_name format a15
col constraint_name format a25
select OWNER,TABLE_NAME,CONSTRAINT_NAME,CONSTRAINT_TYPE,
STATUS,VALIDATED,GENERATED,LAST_CHANGE,INVALID
from user_constraints where lower(table_name)='&table_name';
set linesize 200
col owner format a15
col table_name format a15
col constraint_name format a25
select OWNER,TABLE_NAME,CONSTRAINT_NAME,CONSTRAINT_TYPE,
STATUS,VALIDATED,GENERATED,LAST_CHANGE,INVALID
from user_constraints where lower(table_name)='&table_name';
Comments