-
stored objects
Hi All,
How to list the source code list of stored trigger, procedure, function and pkgs.
Thanks in advance
-
Select text from user_source where type='PROCEDURE and name='UR_PROC_NAME'
HTH
Srini
-
to get the source code of triggers,
you will have to use user_triggers.
for procedures, packages and functions
you can use user_source.
-Raja
-
Thanks all, One more question what is the best approach to edit/change and how to recompile the trigger etc.
Thanks
-
To recompile a trigger
alter trigger compile
what do u mean edit/change?
do u mean editing procedures,functions? if thats the case use a tool like TOAD or u can use a notepad also.
HTH
Srini
-
sorry it shuld be
alter trigger triggername compile
Srini
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|