Create boolean attribute in Oracle? [duplicate]

Question

I have to create a table in Oracle and one column I have to make it of Boolean type. Can you please tell me how can I do that? I have searched on the internet but I couldn't find a clear answer.

Answer 1

There is no BOOLEAN datatype in SQL. But we can represent it like this:

CREATE TABLE tt
  (test NUMBER(1) NOT NULL CHECK  (test in (0,1)))