Re: Reverse engineering a view

You can see the view's SQL script using PowerBuilder or PowerDesigner.

On Sun, 12 Oct 1997 09:25:55 -0500, Asheesh & Anjali <ashanjali_at_multipro.com> wrote:
>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 26 1997 - 00:00:00 CDT