-
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
Imti
Junior DBA
-
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
-
Regarding procedure Information
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
Imti
Junior DBA
-
Hi
You can use something like TOAD which is a freeware for that..:-)
regards
Hrishy
-
Re: Regarding procedure Information
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
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
|