On 8/23/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Boolean is a native SQL datatype.
In Oracle, Boolean is not a native SQL datatype. It is a PL/SQL datatype. In other words, you cannot create a database table having a column with a boolean datatype: H:\SQLplus>sqlplus scott/tiger SQL*Plus: Release 9.2.0.1.0 - Production on Tue Aug 23 15:03:57 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production [EMAIL PROTECTED]> create table t (mycol boolean); create table t (mycol boolean) * ERROR at line 1: ORA-00902: invalid datatype [EMAIL PROTECTED]> create table t (mycol varchar2(1)); Table created. Related Oracle documentation: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c13datyp.htm http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types.htm -- Eddie Awad. http://awads.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216109 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54