Home » SQL & PL/SQL » SQL & PL/SQL » How to see the structure of view on command line (oracle 9i)
How to see the structure of view on command line [message #335010] Sat, 19 July 2008 06:34 Go to next message
ravi214u
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member
Hi,

how to see the structure of view (select column from --)

not desc view.

thanks in advance.

Re: How to see the structure of view on command line [message #335016 is a reply to message #335010] Sat, 19 July 2008 07:49 Go to previous messageGo to next message
pablolee
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
Search through the view DICTIONARY for any data dictionary views that contain the word ....VIEW
Re: How to see the structure of view on command line [message #335019 is a reply to message #335010] Sat, 19 July 2008 09:50 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same thing than for a table.

Regards
Michel
Previous Topic: ORA-01445: cannot select ROWID from a join view without a key-preserved table
Next Topic: parameters of sub functions
Goto Forum:
  


Current Time: Sun Aug 20 04:55:51 CDT 2017

Total time taken to generate the page: 0.08708 seconds