How to see a sequence's design?

[askQs]

Just like: desc table, desc view,
how to "desc" a sequence?
many thanks!

 

[Thargy]

ask,

you should use

DESC USER_SEQUENCES;

this will show you what is there. Obviously to home in on a particular sequence, you should use

SELECT * FROM USER_SEQUENCES WHERE SEQUENCE_NAME = <my_sequence_name>;

Regards

Tharg

Grinding away at things Oracular

 

[LKBrwnDBA]

How about:

SELECT * FROM DBA_SEQUENCES
  WHERE owner = 'MYSCHEMA'
    AND sequence_name = 'MYSEQ';

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Thargy]

lkbrwndba,

I agree, but not everybody has DBA privileges, askQs might be logged in as an ordinary punter. Other than that, your answer is obviously better, as it's most comprehensive.

Regards

Tharg

Grinding away at things Oracular

 

[LKBrwnDBA]

You are correct Tharg.

PS: Seems we hit the 'submit' button at the same time!

Cheers.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb