RishOraDev's Oracle Blogs

The Boolean Data Type has been introduced in Oracle Database 23ai. In this post, we will look at how we can use this new data type. Let us create a table called INVOICES with two columns – Invoice Number and Paid Status. We use the Boolean Data Type for the Paid Status column. SQL> CREATE TABLE invoices(invoice_num VARCHAR2(10), paid_status BOOLEAN);Table