Home » SQL & PL/SQL » SQL & PL/SQL » See the sql behind the view
See the sql behind the view [message #203305] Tue, 14 November 2006 13:02 Go to next message
Matthew Waugh
Messages: 71
Registered: October 2004
I have a view that is returning odd results, and I need to know the full sql code that drives it....

How can pull the view's select statement in SQL+?

Thanks in advance!
Re: See the sql behind the view [message #203315 is a reply to message #203305] Tue, 14 November 2006 14:59 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select text
  from user_views
 where view_name = ?

You may need to 'set long ????' to a high enough value depending on your view source length.
Previous Topic: Call procedure
Next Topic: Poor Performance of aggregate Function
Goto Forum:

Current Time: Fri Oct 21 11:51:56 CDT 2016

Total time taken to generate the page: 0.11006 seconds