Thursday, June 29, 2017

Get DDL for Primary & Foreign Key constraints.

primary

set pages 9999
select DBMS_METADATA.GET_DDL('CONSTRAINT','&constarnt_name','&owner') from dual;


forgien key
set pages 9999
select DBMS_METADATA.GET_DDL('REF_CONSTRAINT','&constarnt_name','&owner') from dual;