Oracle 11gR2
----------------------------------------------------------
Hi,
I want to test, if I am getting the current or original sequence DDL.... Once we start using the sequences, sequence values will change, and I like to know if I use the below query to get the original sequence creation DDL is correct? I don't want to get current sequence values to create another sequence that makes no sense.Thanks!
SELECT DBMS_METADATA.GET_DDL('SEQUENCE','SEQUENCE_NAME') FROM DUAL