OraFAQ Forum: Server Administration » Representing a BOOLEAN style FLAG (or simillar) in a table column?

Home » RDBMS Server » Server Administration » Representing a BOOLEAN style FLAG (or simillar) in a table column?

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

Representing a BOOLEAN style FLAG (or simillar) in a table column? [message #370972]

Wed, 26 July 2000 17:53

Dominic
Messages: 7
Registered: July 2000

Junior Member

Hi
I wondered if anyone could help. Is there no BOOLEAN style datatype in Oracle? I believe other RDBMS have a 'BIT' datatype .... ? Is there any way in Oracle better than using:

variable_name NUMBER(1) CHECK variable_name <=1

I'd really appreciate any input from people, thanks.
Dom

Report message to a moderator

Re: Representing a BOOLEAN style FLAG (or simillar) in a table column? [message #370983 is a reply to message #370972]

Fri, 28 July 2000 12:42

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

Oracle is optimized fine for text and numbers, so no performance worries. I would go with number(1) but change the check constraint to by "col_name in (0, 1)"

Report message to a moderator

Previous Topic:	About table and Column Comments
Next Topic:	Re: @corelated subquery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 22 12:00:27 CDT 2026