How Can I Suppress A New Line Between Select Statements In Sqlplus Script?
(Doc ID 559882.1)
Last updated on MARCH 08, 2017
Applies to:SQL*Plus - Version: 10.2.0.2.0
Information in this document applies to any platform.
When running the following script in SQL+:
set linesize 11
set feedback off
set heading off
set serveroutput off
set termout off
set newpage none
select to_char(mydate,'dd.mm.yyyy') || ';' from mytable;
select to_char(sysdate, 'dd.mm.yyyy') || ';' from dual;
select trim(count(*)) || ';' from mytable;
The output generated is:
How can the new lines between statements be suppressed and the following output be achieved?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.|