Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: boolean type in Oracle..
There isn't a byte type either. You can use number(1,0) or char(1) or
varchar2(1) and use a constraint.
Jim
<gerryt_at_gtconnect.net> wrote in message
news:mF3T7.447$YA3.32138_at_localhost...
> How do you declare a "boolean" type in Oracle?
> I mean nicely : >
>
> In Postgres you can do this in a table:
>
> create table BLAH (
> var1 VARCHAR(10),
> var2 BOOLEAN );
>
> Id rather not use BYTE and then use CHECK Y,N,YES,y,NO,n,0,1 kind of
> thing if I can avoid it. : >
>
> Thanks
Received on Sun Dec 16 2001 - 10:26:15 CST