Home » RDBMS Server » Server Administration » Representing a BOOLEAN style FLAG (or simillar) in a table column?
Representing a BOOLEAN style FLAG (or simillar) in a table column? [message #370972] Wed, 26 July 2000 17:53 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 07 17:42:58 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.