| |
 |
|
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
constraint_name,
decode(constraint_type,'P','Primary Key',
'R','Foreign Key',
'U','Unique',
'C','Check',
'D','Default'),
search_condition,
table_name,
r_owner,
r_constraint_name,
delete_rule
from user_constraints
SEE CODE DEPOT FOR FULL SCRIPT
order by owner;
cursor cons_col (cons_name in varchar2) is
select
owner,
constraint_name,
column_name
from user_cons_columns
SEE CODE DEPOT FOR FULL SCRIPT
order by owner, constraint_name,
position;
cursor get_cons (tab_nam in varchar2) is
select distinct
OWNER,TABLE_NAME,CONSTRAINT_NAME,CONSTRAINT_TYPE
from cons_temp
SEE CODE DEPOT FOR FULL SCRIPT
The above is from the bestselling book
Mike Ault’s Oracle Internals Monitoring & Tuning Scripts.
It's only $49.95and you can download all the scripts immediately:
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |
|
|
