Re: A boolean data type?

From: Kevin Neel <k-neel_at_nwu.edu>
Date: 27 Jan 1994 22:19:19 GMT
Message-ID: <2i9el7$1n4_at_anaxagoras.ils.nwu.edu>


In article <2i63ss$q6d_at_solaris.cc.vt.edu> Scott Huddle, scott.huddle_at_vt.edu writes:
I guess what I'd really like to do is treat the variable like in C, where I could
then write a query like this:

        select from Table where State

or

        select from Table where not State

Anyway to do that?

Nope (unless V7 added it). Would be nice. The standard in Oracle Applications is to have a one-char column and place 'Y' or 'N' in it, and of course replacing State above with State = 'Y'. Received on Thu Jan 27 1994 - 23:19:19 CET

Original text of this message