trimming lines

Shell Programming and Scripting
1

hi have output as

i have trim of lines before CREATE statement and lins after last ")"

any idea how to achieve it ?

2

you can put your select statement into a script which calls, amongst other things:

set echo off
set feedback off
spool out.sql
select ...
spool off

then call your script from the prompt:

SQL> @myscript;

You can probably get your semicolon on the end of the result with concatenation:

select DBMS_METADATA.GET_DDL('INDEX','I_QOSSYSTA2IRAQOS_____N')||';' from dual

check out this site for more info on sqlplus set: sqlplus set command

hth,
dv

3

code ==>

output ==>

4

don't think this works

set term off echo off;

try this

set term off;
set echo off;