Re: View problem...
From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 29 Jul 1999 20:59:54 GMT
Message-ID: <7nqfca$hm8_at_gap.cco.caltech.edu>
Date: 29 Jul 1999 20:59:54 GMT
Message-ID: <7nqfca$hm8_at_gap.cco.caltech.edu>
[Quoted] 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 - 22:59:54 CEST