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