Re: View problem...

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 Thu Jul 29 1999 - 11:06:34 CDT