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: 2834
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same thing than for a table.

Regards
Michel
Previous Topic: SQL Question
Next Topic: ORA-00942: table or view does not exist
Goto Forum:
  


Current Time: Sat Dec 03 22:02:10 CST 2016

Total time taken to generate the page: 0.08292 seconds