Forum Stats

  • 3,874,444 Users
  • 2,266,734 Discussions
  • 7,911,851 Comments

Discussions

SQLcl incorrect column width for DATE when first row NULL

user2530729
user2530729 Member Posts: 9 Blue Ribbon

Problem: SQLcl incorrect column width for DATE when first row NULL


(Works properly in SQLPlus)

1) See attached test SQL: ColDateTest.sql

2) Run in SQLPlus and SQLcl (binary) against same schema

3) Compare outputs: output_sqlcl.txt vs output_sqlplus.txt

4) My environment: JDK 1.8.0_291, SQLcl 21.1.1, SQL*Plus: Release 12.2.0.1.0 Production

Any suggestions?

Thanks!

Bob

Best Answer

Answers