0

In wide sqlplus reports, column headers get misaligned from the data

enter image description here

The code that led to this output was:

set linesize 32767
set trimspool on

col z format a1

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

pro....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+....3
select sysdate a, sysdate b, sysdate c, sysdate d, sysdate e, 'yyyyyyyyyyy' y, 'z' z from dual;

select sysdate a, sysdate b, sysdate c, sysdate d, sysdate e, sysdate f, 'z' z from dual;

How can this be fixed?

1 Answer 1

0
set tab off

fixes the problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.