Re: Q : SQL DATA TYPE QUESTIONS

Hey Jean,

     You could try using a check constraint in lieu of the unsupported boolean type:

CREATE TABLE mytable
 (mybool CHAR(1)

    CONSTRAINT mytable_mybool_ck CHECK (mybool in ('T', 'F')),   mychar VARCHAR2(25));

Jay!!!

jean-christophe.ravarini_at_genebio.com wrote:

> Hi all,
>
> Using Oracle8 via SQL_PLUS, I send SQL statments
> to create tables, but the following code doesn't
> work because of the BOOL type, the error message
> is: "ORA-00902: invalid datatype"
>
> CREATE TABLE MyTable (
> MyBool BOOL NULL,
> MyChar VARCHAR2 NULL,
> ) tablespace MyTableSpace;
>
> What is the BOOL equivalent data type in this case ?
>
> Thanks in advance,
>
> Jean Christophe Ravarini
> mailto:jean-christophe.ravarini_at_genebio.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Sep 22 1999 - 11:02:02 CDT