Re: reg.datatypes in oracle
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 06 Jul 1999 16:09:33 -0700
Message-ID: <37828CAC.D0935954_at_exesolutions.com>
Date: Tue, 06 Jul 1999 16:09:33 -0700
Message-ID: <37828CAC.D0935954_at_exesolutions.com>
> I have a script in informix to create a table.In that they have used boolean
> as one datatype.when i port to oracle which datatype I've to use in the case
> of
> boolean because after pressing enter to create table it is giving error in
> that line as invalid datatype.
>
> So please anyone can provide me help.
You will need to create the Oracle field as a CHAR(1) and load it with values of T and F.
Oracle uses BOOLEAN for variable but not as a field type.
Daniel A. Morgan Received on Wed Jul 07 1999 - 01:09:33 CEST