Re: View problem...

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 29 Jul 1999 20:59:54 GMT
Message-ID: <7nqfca$hm8@gap.cco.caltech.edu>

select text from user_views where view_name='YOUR_VIEW';

You may need to set long 2000 first

Robert XU

Jimmy (c6635500_at_comp.polyu.edu.hk) wrote:
: Hello all,

: I have a view in Oracle 7.3. I want to get the table name and the
: column name (of tables) of the view column refers. How can I get the
: above information by query the data dictionary? Or any other ways?

: Thanks,
: Jimmy
Received on Thu Jul 29 1999 - 15:59:54 CDT