OraFAQ Forum: SQL & PL/SQL » table with a boolean column

Home » SQL & PL/SQL » SQL & PL/SQL » table with a boolean column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table with a boolean column [message #258660]

Mon, 13 August 2007 05:07

orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA

Member

Can we create a table with a column of boolean datatype , if yes what is that create table syntax ? How to we insert data in this column? PLS help..........

Report message to a moderator

Re: table with a boolean column [message #258661 is a reply to message #258660]

Mon, 13 August 2007 05:09

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

BOOLEAN isn't among available Oracle column datatypes.

You'll have to make it, for example, a NUMBER(1) and insert 0 for FALSE and 1 for TRUE, or VARCHAR2(1) with T for TRUE and F for FALSE or ...

Report message to a moderator

Re: table with a boolean column [message #258663 is a reply to message #258660]

Mon, 13 August 2007 05:14

ShivrajGutte
Messages: 21
Registered: April 2007
Location: PUNE

Junior Member

Boolean is pl/sql datatype ,It is not supported in Database So we can not create column with boolean datatype.

Regards
Shivraj

Report message to a moderator

Re: table with a boolean column [message #258667 is a reply to message #258660]

Mon, 13 August 2007 05:23

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can accomplish by using check constraint.

SQL> create table check_boolean(
  2  a char(1) check (a in ('T','F')));

Table created.

Report message to a moderator

Re: table with a boolean column [message #258875 is a reply to message #258667]

Mon, 13 August 2007 12:34

Frank
Messages: 7901
Registered: March 2000

Senior Member

Adding a check constraint doesn't make a single character a boolean..

Report message to a moderator

Previous Topic:	How to see all the tables create by me?
Next Topic:	to recompile java objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 11 22:31:33 CDT 2025