Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: is there any way to get the view definition after creating the view?
query the all/dba/user_view table.
set long 10000
SELECT text
from user_view
where name = '<view name>' ;
Ashish Received on Thu Feb 16 2006 - 03:07:21 CST