Source of sequence?

Question

hi,

I want to use source code of some sequences but i am unable to find it in ALL_SOURCE data dictionary. Please let me know where i can find source code for sequences used .

Answer 1

  select * from ALL_SEQUENCES

Answer 2

Try select * from USER_SEQUENCES

This is for sequence created by user.

Answer 3

DBA_DEPENDENCIES / ALL_DEPENDENCIES should tell you what sequences are used by what procedural code -- however, sequences used by dynamic SQL won't be caught.

To be able to view source code - like a package body - in another schema, you'll need the right privileges, and SELECT ANY DICTIONARY is the simplest; otherwise, the DEBUG privilege on the package in the remote schema is required.