OraFAQ Forum: SQL & PL/SQL » Boolean on table

Home » SQL & PL/SQL » SQL & PL/SQL » Boolean on table

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

Boolean on table [message #7790]

Wed, 09 July 2003 04:48

arseni
Messages: 8
Registered: March 2003

Junior Member

How can I put a column with boolean datatype when I create a table? I think that boolean datatype doesn't exists in table definition.

Report message to a moderator

Re: Boolean on table [message #7792 is a reply to message #7790]

Wed, 09 July 2003 06:34

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Make it a Varchar2(1) with a check constraint that restrict possible values to two possibilities: a value for TRUE (e.g. 'Y') and a value for FALSE (e.g. 'N').

Maaher

Report message to a moderator

Re: Boolean on table [message #7793 is a reply to message #7790]

Wed, 09 July 2003 07:38

sandhya
Messages: 15
Registered: February 2002

Junior Member

There is no datatype by boolean.. you can create a field with char of 1

Report message to a moderator

Previous Topic:	Where -clause
Next Topic:	number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:01:02 CDT 2024