Reputation: 5359

Source of sequence?

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 .

Upvotes: 0

Answers (3)

Adam Musch

Reputation: 13583

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.

Upvotes: 1

Pravin Satav

Reputation: 702

Try select * from USER_SEQUENCES

This is for sequence created by user.

Upvotes: 1

Michael Pakhantsov

Reputation: 25370

  select * from ALL_SEQUENCES

Upvotes: 2

Source of sequence?

Answers (3)

Related Questions