How to remove empty lines in multiple selects
Hi,
there is a script:
================
set heading off
prompt prompt1
select 'Text1' from dual;
prompt prompt2
select 'Text2' from dual;
prompt prompt3
select 'Text3' from dual;
================
Output:
================
prompt1
Text1
prompt2
Text2
prompt3
Text3
================
Is there any way to force sqlplus not to put emply line after every select? I can't use external tools like perl/sed/awk to filter it out, I may only change sqlplus settings. I tried with
set heading off newpage none pagesize 0
but it doesn't help. I would appreciate your help with this.