Re: Reverse engineering a view

From: Johannes Wilhelm <x15_at_aixterm8.urz.uni-heidelberg.de>
Date: 1997/10/28
Message-ID: <634e6d$pef@sun0.urz.uni-heidelberg.de>#1/1

Wenchang <ancient_97_at_yahoo.com> wrote:
" 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
" >
" >
" >

/*                                              */
/*   displays text of a view                    */
/*                                              */

set long 5000
select text from user_views
where view_name=upper('&name')
/

Try this from SQLPLUS!

Johannes Received on Tue Oct 28 1997 - 00:00:00 CST