SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Plus Yes/No Values

534123Sep 16 2006 — edited Sep 16 2006

Hey,
I need some help.
I am working with Oracle iSQL*Plus and have to create tables to insert data. One of the data values (PressureRequired) has to be a 'Yes' or 'No'.
At the moment i have it like this, however it doesn't like BOOLEAN as a value.

CREATE TABLE AssetPneumatic
( EquipID CHAR(8),
PressureRequired BOOLEAN,
ConnectorSize INTEGER,
LubricationType CHAR(4),
CONSTRAINT PKAssetPneumatic PRIMARY KEY (EquipID),
CONSTRAINT FKAssetPneumatic FOREIGN KEY (EquipID) REFERENCES AssetEquipment )

Does anyone have any ideas on how to resolve this?
I am very happy to answer any more questions if anyone needs more information.

Thanks
This is kind of urgent

Lutty182

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2006

Added on Sep 16 2006

6 comments

981 views