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 -> How does SQL*Plus's DESCRIBE command work internally?

How does SQL*Plus's DESCRIBE command work internally?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Mon, 22 Apr 2002 15:04:54 +0200
Message-ID: <3cc40a77$0$271$edfadb0f@dspool01.news.tele.dk> 





How does SQL*Plus's DESCRIBE command work internally? For
tables/views/object types it's easy, but how does it determine the
procedures/functions in a package? The source code could be parsed (but
DESCRIBE seems too fast) and what if the source code is wrapped?



Some internal (or hopefully public) data dictionary views must keep this
information and I'm interested in accessing that information.



Cheers,



Finn
Received on Mon Apr 22 2002 - 08:04:54 CDT












Original text of this message













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