Regarding Procedure Information

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

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

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

Hi

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

regards
Hrishy

Quote:

---

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.