show a view's sql

Hello,

I cannot find the method to display a view's SQL. Not DESC or SELECT * FROM VIEW_NAME but the manner in which I can see the SQL which makes up the guts of an existing view. I know I have to SET LONG 2000 beforehand to see the whole thing but what comes afterwards?

I tried looking at it from Schema Manager as well but the display is chopping off a good portion of the existing SQL.

Thanks! Received on Tue Oct 11 2005 - 12:45:13 CDT