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: How to open a cursor for the results of describe?

Re: How to open a cursor for the results of describe?

From: Noel <tbal_at_go2.pll-l>
Date: Mon, 14 Mar 2005 12:54:16 +0100
Message-ID: <d13ubt$c0n$1@inews.gazeta.pl> 





Użytkownik Roel Schreurs napisał:



> Hi All,

> 

> DESCRIBE <synonym>, using Toad, the column structure shows up nicely.




Remember, that synonym is a pointer to object, and have no structure itself.
Look at ALL_SYNONYMS view, in column TABLE_NAME you get object name 
which is pointed by synonym.



-- 
Noel


Received on Mon Mar 14 2005 - 05:54:16 CST












Original text of this message













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