get sequence definition in oracle

[xzhang9]

Hi all,

I am using toad with oracle and it is just easy to get the sequence definition viewing the script

CREATE SEQUENCE ABC
START WITH 1048
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
NOCACHE
NOORDER;

How can we get this definition from sqlplus. I am doing this because I need to dynational run a sql file in sqlplus to recreate it after some process.

Thanks,

Jane

[Paul Sperry]

select * from dba_sequences where SEQUENCE_NAME='SEQUENCE_NAME_SEQ';

[Paul Sperry]

in your case


select * from dba_sequences where SEQUENCE_NAME='ABC_SEQ';

[xzhang9]

Thanks for your answers, that's what I need to generate sql with sql.
Jane

[xzhang9]

Thanks for your answer, that's what I need to generate sql with sql.
Jane

[Paul Sperry]

to generate objects withing sql use the select into statement

[Yogeeraj_1]

hi Jane,

can you try the following?

select 'create sequence '||sequence_name||' start with '||last_number||' maxvalue '||max_value||' minvalue '||min_value||decode(ORDER_FLAG,'N',' noorder',null)||decode(CYCLE_FLAG,'N',' nocycle',null)||'cache '||cache_size||' increment by '||increment_by||';' from dba_sequences
where sequence_name='ABC'
/

hope this helps!

kind regards
yogeeraj