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: A $ sign in PLSQL variables names or procedure name
Next Topic: export `create table`, 'insert into`...
Goto Forum:

Current Time: Wed Aug 23 05:15:08 CDT 2017

Total time taken to generate the page: 0.01778 seconds