Skip to Main Content

I want to test, if I am getting the current or original sequence DDL ?

Erhan_torontoSep 7 2013 — edited Sep 7 2013

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

Comments
Post Details
Added on Sep 7 2013
10 comments
542 views