set verify off
set feedback off
set lines 300
set pages 0
set heading off
set space 0
column text format a79
column line noprint
select DECODE(line,1,’create or replace ‘,”)||text, line
from dba_source
where owner = upper(‘&owner’)
and type = upper(‘&type’)
and name = upper(‘&name’)
and line >= 1;
Recent Posts
