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 .
From stackoverflow
-
select * from ALL_SEQUENCES -
Try select * from USER_SEQUENCES
This is for sequence created by user.
-
DBA_DEPENDENCIES / ALL_DEPENDENCIESshould 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 DICTIONARYis the simplest; otherwise, the DEBUG privilege on the package in the remote schema is required.
0 comments:
Post a Comment