Re: View problem...

From: Pradhan <empradhan_at_dplus.net>
Date: Thu, 29 Jul 1999 21:04:41 -0400
Message-ID: <aR6o3.346$sN3.2267@newsfeed.slurp.net>

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