Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle For Fun

Re: Oracle For Fun

From: Tony <andrewst_at_onetel.net.uk>
Date: 30 Jan 2004 14:25:33 -0800
Message-ID: <c0e3f26e.0401301425.480ee613@posting.google.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1075478492.840717_at_yasure>...
> Tony wrote:
>
> > zmilos_at_sympatico.ca (zhix) wrote in message news:<c59f4459.0401291445.5df87e31_at_posting.google.com>...
> >
> >>i know.. dammit..
> >>because it returns boolean..
> >>
> >>should call it with sumtin like:
> >>
> >>BEGIN
> >> IF valid_code('22-33-44') THEN
> >> dbms_output.put_line('True');
> >> ELSE
> >> dbms_output.put_line('False');
> >> END IF;
> >>END;
> >>/
> >>
> >>:-(
> >
> >
> > Right: WHEN will Oracle add Boolean support to its SQL, please???
>
> That IS Boolean support. Microsoft IIRC uses 0 and -1 which are integers
> ... not Booleans. Ask Microsoft to implement Booleans as they have yet
> to do so ... not Oracle.

I said to its SQL, not PL/SQL. I mean, being able to create a column of datatype BOOLEAN, and (in particular here) being able to call functions that return BOOLEAN values. As for what Microsoft supports, I have no idea. I don't think Oracle should not do something just because Microsoft does even less. Received on Fri Jan 30 2004 - 16:25:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US