Regarding Procedure Information

[akimtiaz]

Dear All,
I want to get name of all procedure and functions which are created.I also want the coding for the particular procedure.Can u help me that from which table I can get these all information.


Regards,
Imti

[hrishy]

Hi

You can get that from all_objects..

something like

select object_name,owner,object_type
from all_objects
where object_type in ('PROCEEDURE','FUNCTION');

regards
Hrishy

[akimtiaz]

Thanks Harishy,

Now I got it how to get information regarding procedure and functions.I want one more help suppose I want to see my coding in my existing procedure for example test_proc. how can I edit it?


Regards,
Imti

[hrishy]

Hi

You can use something like TOAD which is a freeware for that..:-)

regards
Hrishy

[abhaysk]

Originally posted by akimtiaz
Thanks Harishy,
I want to see my coding in my existing procedure for example test_proc. how can I edit it?
Regards,
Imti

Select text from dba_source where name='TEST_PROC';

U will get the code of the proc.