NUMBER vs BOOLEAN in Oracle OPERATOR

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 22 Jul 2002 13:04:00 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70266DA88@lnewton.leeds.lfs.co.uk>

If I'm not mistaken, Booleans are only supported in PL/SQL and not as column datatypes nor are they supported in SQLPlus itself. But, I may not be remembering properly.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: sburgeon_at_hotmail.com (Spencer) [mailto:sburgeon_at_hotmail.com] Posted At: Friday, July 19, 2002 3:03 PM Posted To: server
Conversation: NUMBER vs BOOLEAN in Oracle OPERATOR Subject: NUMBER vs BOOLEAN in Oracle OPERATOR

Hello everyone. Despite the apparently obvious error message given by Oracle, can someone please tell me why the first operation below works, and the second one doesn't. I don't understand. Isn't a BOOLEAN just like any other Oracle internal datatype (eg VARCHAR2, NUMBER) ?

<SNIP> Received on Mon Jul 22 2002 - 07:04:00 CDT