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: Obtaining a views' column origin

Re: Obtaining a views' column origin

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 04 Jul 2002 19:59:36 GMT
Message-ID: <3D24A900.29F38496@exesolutions.com> 





Helmut Vogel wrote:



> Hi,

>

> i need to obtain the underlying column and table name of a view's column. Can I

> get this info from the data dictionary?

> I use Oracle Server 8.1.6.1.0

> Thanx 4 help!

>

> Helmut

> --

> __________________________________________________________

> News suchen, lesen, schreiben mit http://newsgroups.web.de




SET LONG 4000


SELECT text


FROM all_views


WHERE view_name =



Daniel Morgan
Received on Thu Jul 04 2002 - 14:59:36 CDT












Original text of this message













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