Re: Datatype in Oracle
From: Jac. _at_ xs4all <jbeekers_at_xs4all.nl>
Date: Wed, 7 Oct 1998 21:00:41 +0200
Message-ID: <6vgdon$fm7$1_at_news2.xs4all.nl>
Date: Wed, 7 Oct 1998 21:00:41 +0200
Message-ID: <6vgdon$fm7$1_at_news2.xs4all.nl>
Oracle doesn't have a datatype "boolean", at least not in the database. Use the datatype CHAR with a length of 1 and use a check constraint to be sure only two values (i.e. T and F) are allowed.
Jac.
Ken Ho Kwok Fai wrote in message <6vg5c9$5nb_at_eng-ser1.erg.cuhk.edu.hk>...
>I am using Oracle 7.3.2 in Unix. I want to know the format of the
>datatype "Date". What format I should use to input a date to the database
>which type is "Date"? Another problem is about Boolean type. Do oracle
>support "Boolean" type? Thanks you for your kind attention.
>
>--
>Regards,
>Ken
Received on Wed Oct 07 1998 - 21:00:41 CEST