Re: using boolean data type in Oracle [message #7133] |
Thu, 22 May 2003 19:25 |
Bhavin Patel
Messages: 2 Registered: May 2003
|
Junior Member |
|
|
hi, i want to use a boolean datatype in oracle, i have implemented it using the follwoing command
Represents_Institute boolean constraint representsinstitute_notnull not null,
inside a table, however it gives me an error
Could someone please help me out here...
|
|
|
Re: using boolean data type in Oracle [message #7137 is a reply to message #7133] |
Fri, 23 May 2003 01:44 |
Martin Chadderton
Messages: 35 Registered: May 2003
|
Member |
|
|
Hi There.
yes, you can't create a table with a column of type BOOLEAN. BOOLEAN is not a SQL datatype, it's PL/SQL only.
SQL> CREATE TABLE t ( a BOOLEAN );
CREATE TABLE t ( a BOOLEAN )
*
ERROR at line 1:
ORA-00902: invalid datatype
Regards
|
|
|