If you don't have sucess with USER_VIEWS then try ALL_VIEWS !
Pete Sharman <psharman_at_us.oracle.com> wrote in article
<37A07C0A.238B56CB_at_us.oracle.com>...
> Jimmy
>
> You can get the complete view definition from the view USER_VIEWS:
>
> set long 2000
> select text from user_views
> where view_name = 'MY_VIEW_NAME';
>
> text is a long column, so the set long command should be used to expand
> the amount of text shown when running the select.
>
> HTH.
>
> Pete
>
> Jimmy wrote:
>
> > 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
>
> --
> Regards
>
> Pete
>
>
Received on Fri Jul 30 1999 - 07:28:00 CDT
