Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trying to create a simple view against system view. Don't think possible
create view testview (table_name) as select table_name from dba_tab_columns;
worked fine for me !
> Eg "create view testview (table_name) select as table_name from
> dba_tab_columns" won't work.
Received on Tue Feb 13 2001 - 04:13:07 CST