Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Listing all Stored Procedure in database

Re: Listing all Stored Procedure in database

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 11 Jul 2003 14:17:52 -0700
Message-ID: <336da121.0307111317.2bb9086d@posting.google.com> 





vicnjowusi_at_hotmail.com (Egbon) wrote in message news:<372e7dae.0307110827.585d7be1_at_posting.google.com>...


> Hi,

> 

> What command can I use to list all the Stored Procedures in Oracle

> database. I am new to Oracle.

> 

> Thanks.

> 

> Egbon




  1  select object_name


  2  from dba_objects


  3* where object_type = 'PROCEDURE'
Received on Fri Jul 11 2003 - 16:17:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US