Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View problem...
Hi
You can view the view create statement with following
Select text from user_views where view_name ='<view name>';
before that set the long value to 2000 or more.
SET long 2000
Select text from user_views where view_name ='<view name>';
that will give you the create statement of view.
HTH
pradhan
Jimmy wrote in message <37A10FB6.B64DBA3D_at_comp.polyu.edu.hk>...
>Hello all,
>
> I have a view in Oracle 7.3. I want to get the table name and the
>column name (of tables) of the view column refers. How can I get the
>above information by query the data dictionary? Or any other ways?
>
>Thanks,
>Jimmy
>
Received on Thu Jul 29 1999 - 20:04:41 CDT