- Arun Kumar
Get DDL command for VIEW
The below statement will give CREATE VIEW command to respective view names that you provide:
set long 20000;
set pagesize 0 ;
set linesize 1000;
set feedback off ;
set verify off ;
set trimspool on;
column text for a1000;
SELECT text
FROM dba_views
WHERE view_name = '&VIEW_NAME';
57 views