Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reverse engineering a view

Re: Reverse engineering a view

From: Asheesh & Anjali <ashanjali_at_multipro.com>
Date: 1997/10/12
Message-ID: <3440DDF3.8D8513A7@multipro.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US