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

Home -> Community -> Usenet -> c.d.o.misc -> Re: can I see the procedures in a package thru SQLPLUS???

Re: can I see the procedures in a package thru SQLPLUS???

From: NeilC <neilc-olops_at_btinternet.com>
Date: Wed, 27 Oct 1999 12:01:15 +0100
Message-ID: <3816DB7B.3E399DB8@btinternet.com> 





You can try doing the following



sql> desc packagename



HTH neil



James Belton wrote:



> I want to be able to see which procedures are stored in a package or even


> which package a procedure might be in, using SQLPLUS.


>


> I've trawled thru the SYS tables and views and can't find anything


> obvious...... does anybody know how to do this???



Received on Wed Oct 27 1999 - 06:01:15 CDT












Original text of this message













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