Home » SQL & PL/SQL » SQL & PL/SQL » View details
View details [message #580] Fri, 22 February 2002 07:46 Go to next message
Andre
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.

Report message to a moderator

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');

Report message to a moderator

Previous Topic: date datatype
Next Topic: Exponential and Log functions?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 04:58:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.