Oracle export SEQUENCE.
select trim(DBMS_METADATA.GET_DDL('SEQUENCE',a.OBJECT_NAME, a.OWNER)) "SEQUENCE_DDL" from dba_objects a where a.OBJECT_TYPE ='SEQUENCE' and a.OWNER in ('USERNAME') order by a.OWNER, a.OBJECT_NAME; |
||
select trim(DBMS_METADATA.GET_DDL('SEQUENCE',a.OBJECT_NAME, a.OWNER)) "SEQUENCE_DDL" from dba_objects a where a.OBJECT_TYPE ='SEQUENCE' and a.OWNER in ('USERNAME') order by a.OWNER, a.OBJECT_NAME; |
||