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 -> Trying to create a simple view against system view. Don't think possible

Trying to create a simple view against system view. Don't think possible

From: Techie <webmaster_at_syncsoft.com.au>
Date: Tue, 13 Feb 2001 10:43:08 +1000
Message-ID: <563i6.23669$65.118547@newsfeeds.bigpond.com> 






I am trying to create a view against the dba_tab_columns data dictionary
view.  It is a view, not a table.  In normal cases standard SQL allows you
to create a view against a view, but in this case I don't believe it is
supported under Oracle.  Is there are a workaround.



Eg "create view testview (table_name) select as table_name from
dba_tab_columns" won't work.
Received on Mon Feb 12 2001 - 18:43:08 CST












Original text of this message













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