Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NUMBER vs BOOLEAN in Oracle OPERATOR
Norman is correct. Boolean datatypes are only available in PL/SQL.
Roger Crowley - DBA - LearningFramework
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA70266DA88_at_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 - 08:20:20 CDT