Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> boolean type in Oracle..

boolean type in Oracle..

From: <gerryt_at_gtconnect.net>
Date: Sun, 16 Dec 2001 16:07:46 GMT
Message-ID: <mF3T7.447$YA3.32138@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:07:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US