sql> select * from dba_objects - to get the name sql> describe object_name - to get description then its down into the data dictionary to extract the code for it, drop the bugger and recreate it ;o)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 August 2002 08:33 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: Oracle viewing procedures Hi Guys, Can anyone remember which table Oracle stores procedures/functions in? I've got to edit a procedure that is stored on the server, but I don't have the source. I know it was obviously created with CREATE PROCEDURE... but can't remember which table/view these are stored in. Thanks Karl. Karl O'Sullivan Senior Analyst Programmer University Hospitals Coventry and Warwickshire NHS Trust Tel: 024 7660 2020 x7578 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
