Home » SQL & PL/SQL » SQL & PL/SQL » Re: Question
Re: Question [message #2160] Tue, 25 June 2002 04:15
ajay
Messages: 45
Registered: December 2000
Member
Hi,

To list all the VALID procedures in the database
Select Owner, Object_Name, Object_type
from dba_objects
where object_type = 'PROCEDURE'

To see the text of the procedures in SQL PLUS

set heading off
select text from dba_source
where name = &1
and type = 'PROCEDURE';

Cheers

Report message to a moderator

Previous Topic: EXISTS
Next Topic: select a set of records
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 00:28:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.