Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> how to retrieve view definition
How do I retrieve view definition from SQLPLUS? I tried to "select text from all_views where view_name='MY_VIEW'" but the returned text was too long to display on a single line and was truncated. I tried to 'set wrap on' but it did not help.
Thanks.
SF
Sent via Deja.com
http://www.deja.com/
Received on Fri Dec 22 2000 - 08:44:01 CST