TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- clear columns breaks computes
- column owner format a20 heading 'Owner' print entmap off;
- column constraint_name format a30 heading 'Constraint Name' print entmap off;
- column constraint_type format a15 heading 'Constraint Type' print entmap off;
- column table_name format a30 heading 'Table Name' print entmap off;
- break on owner on table_name
- select owner,
- table_name,
- constraint_name,
- decode(constraint_type,
- 'C',
- 'check constraint on a table',
- 'P',
- 'primary key',
- 'U',
- 'unique key',
- 'R',
- 'referential integrity',
- 'V',
- 'with check option, on a view',
- 'O',
- 'with read only, on a view',
- null) constraint_type
- from dba_constraints
- where status = 'DISABLED'
- order by 1, 2;
复制代码
|
|