Hello,
I'm using SQLcl Production Release sqlcl-4.2.0.17.097.0719.
When I type a simple SELECT * FROM TABLE statement all in the same line as the prompt, OR if I type-in SELECT * FROM TABLE spreading over multiple-lines and execute it, the results are shown with column headers appearing directly besides the statement termination character (whether ; or /) on that line, instead of displaying the column headers nicely on the next new line. Due to this, the column headers are misaligned with the results.
My login.sql file (for SQLcl) includes the following commands:-
SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER>"
SET SERVEROUTPUT ON SIZE 1000000;
SET PAGESIZE 200;
SET LINESIZE 32767;
SET LONG 1000000;
SET TIMING ON;
SET SQLFORMAT ANSICONSOLE;
SET NULL <NULL>;
define _EDITOR=inline;
Any idea how do I ensure that no matter how many lines I type-in my SQL statement and execute it, the column headers and results are always shown on a new line separate from the statement?
Sam
@"Jeff Smith Sqldev Pm-Oracle"
@"Kris Rice-Oracle"