How to get the create statement of sql view
SELECT owner "view owner name", view_name "view name"
FROM all_views
WHERE view_name = :view_name
SELECT DBMS_METADATA.get_ddl ('VIEW', 'view name',
'view owner name')
FROM DUAL
FROM all_views
WHERE view_name = :view_name
SELECT DBMS_METADATA.get_ddl ('VIEW', 'view name',
'view owner name')
FROM DUAL
