Sqlplus formatting

set echo off
set verify off
set heading off
set feedback off
set pagesize 0
set linesize 600
set trimpool on
col aaa a 10

accept┬ámyparameter prompt ‘Bla bla enter parameter:’

 

spool myfiole.lst

select ‘&myparameter’ aaa from dual

 

spool off

col aaa clear