OraFAQ Forum: Server Administration » Procedure / functions in oracle

Home » RDBMS Server » Server Administration » Procedure / functions in oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Procedure / functions in oracle [message #62459]

Thu, 22 July 2004 21:55

Venkat
Messages: 110
Registered: February 2001

Senior Member

Hi ,
through what views can i see my procedures/functions� list and procedure/function body existing in a� particulr schema from a command promt.

Thanks ,
Venkat

Report message to a moderator

Re: Procedure / functions in oracle [message #62460 is a reply to message #62459]

Fri, 23 July 2004 00:21

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

Try the following to list all procedures/functions in your schema:

SQL> select distinct type, name from user_source;

TYPE         NAME
------------ ------------------------------
FUNCTION     TEST
PROCEDURE    HELLO
TRIGGER      TRG_PHONE_NUMBERS

To look at any particular functions/procedure's source:

SQL> select text from user_source where name = 'HELLO' order by line;

TEXT
--------------------------------------------------------------------------------
procedure hello as
begin
  null;
end;

Best regards.

Frank

Report message to a moderator

Re: Procedure / functions in oracle [message #62461 is a reply to message #62459]

Fri, 23 July 2004 00:22

Anu
Messages: 82
Registered: May 2000

Member

hi!
try it out
select name, body from user_source where type='FUNCTION';

Hope it helps u
anu

Report message to a moderator

Previous Topic:	Oracle10g
Next Topic:	Am unable to create database on IBM AIX Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 09 13:28:27 CDT 2025