Re: is there any way to get the view definition after creating the view?

Ramu wrote:
> Hai,
>
> Please tell me how can we get the definition of view after the creation
> of a view?

set long 1000000

SELECT dbms_metadat.get_ddl('VIEW', 'name_of_the_view) FROM dual;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)