Skip to Main Content

Oracle Database Free

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!

BOOLEAN Data type displaying 1, 0 in SQLcl and SQLPlus

Brendan TApr 7 2023

The docs show the BOOLEAN data type as displaying TRUE/FALSE when queried from a table.

When I try it, I get 1/0s being displayed, in both SQLcl (23.1) and SQL*Plus (19.8) (Docker DB image).

Any ideas why or do I need to change or set something?

This post has been answered by Gerald Venzl-Oracle on Apr 7 2023
Jump to Answer
Comments
Post Details
Added on Apr 7 2023
1 comment
867 views