Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reverse engineering a view
You should probably set long a large number say 5000 and should be able to see the whole text for the view. The sqlplus command for this is : set long 5000
Hope this helps.
briankh_at_umich.edu wrote:
> 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 Sun Oct 12 1997 - 00:00:00 CDT