SQL*Plus (MOSC)

MOSC Banner

How to remove empty lines in multiple selects

edited Aug 8, 2014 7:03AM in SQL*Plus (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center