Home » SQL & PL/SQL » SQL & PL/SQL » View details
View details [message #580] Fri, 22 February 2002 07:46 Go to next message
Messages: 7
Registered: January 2002
Junior Member
Is there a way to see the query that was used to create a view? i.e. what tables were used and the fields from each. I know the about the desc command but this doesn't give me what i want.
Re: View details [message #586 is a reply to message #580] Fri, 22 February 2002 10:02 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
sql>set long 2000
sql>select text from all_views where view_name=upper('&view');
Previous Topic: date datatype
Next Topic: Exponential and Log functions?
Goto Forum:

Current Time: Sun Sep 19 11:30:55 CDT 2021