this is a extract from a piece of code to extract views text (long type) from data dictionary; a task similar to one you have.
Hope this will give you an idea how to solve your problem.
create table obj_generate (
oseq number,
oline varchar2(4000));
declare
output_line...
try these modifications to your script:
set serveroutput on
Server Output ON
set timing off
set time off
set term off
set feedback off
set heading off
set echo off
spool run_host.sql
SELECT 'host...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.