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;
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;
No comments:
Post a Comment