Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl incorrect column width for DATE when first row NULL

user2530729Jun 30 2021

Problem: SQLcl incorrect column width for DATE when first row NULL
20210630_SQLcl_ColDateWidth-Null.zip (3.47 KB)
(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
This post has been answered by user2530729 on Jul 2 2021
Jump to Answer

Comments

Processing

Post Details

Added on Jun 30 2021
1 comment
93 views