Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reverse engineering a view
The text column in all_views is of long data type. If you are in sqlplus, try "set long 8888888"
briankh_at_umich.edu wrote in article <343D11CE.C5BC53EE_at_umich.edu>...
> I need to find out the join conditions of a view that joins two tables.
>
> I have found sql scripts that I believe created some of the other views
> I'm working with but, cannot find any for this one. I've looked at the
> entry in the ALL_VIEWS table and can see only the first several
> characters of the text that created this view.
>
> How can I find out what a view is doing?
>
> Brian Harcourt
> University of Michigan
> briankh_at_umich.edu
>
>
Received on Thu Oct 09 1997 - 00:00:00 CDT