Create a Boolean column in Oracle Database

Asked

Viewed 106 times

0

In an oracle bank I have to create a column with the Boolean type

ALTER TABLE dbamv.prepad ADD editable BOOLEAN default FALSE;

But the database displayed an error message:

ORA-00902: invalid data type ALTER TABLE dbamv.pre_pad ADD editable BOOLEAN default FALSE

sql oracle pl-sql boolean

  • is the same problem your believe https://stackoverflow.com/questions/19518415/boolean-giving-invalid-datatype-oracle

  • Oracle does not support this type, create as NUMBER(1) and include a Constraint for 0 or 1 https://imasters.com.br/banco-data

No answers

Browser other questions tagged sql oracle pl-sql boolean

You are not signed in. Login or sign up in order to post.