spool all_cons.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;

break on "OWNER" on "TABLE";

/* ****************************************************** */
/*                                                        */
/*  - will show all the constraints for a given database  */
/*                                                        */
/*         @c:\oracle\sql\all_cons.sql                    */ 
/*                                                        */
/* ****************************************************** */

select 	substr(owner,1,10)                      "OWNER",
        substr(table_name,1,15)               	"TABLE",
        substr(constraint_name,1,15)		"CONSTRAINT",
        constraint_type				"T",
	status					"STATUS"
from 	all_constraints 
order by 1 asc, 2 asc, 3 asc;

set echo off;
spool off;
set long 80;
commit;









