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';

Was this article helpful?

Related Articles

Leave a Comment