Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!border1.nntp.ash.giganews.com!border2.nntp.sjc.giganews.com!nntp.giganews.com!cyclone-sf.pbi.net!216.218.192.242!news.he.net!newsfeed1.easynews.com!easynews.com!easynews!elnk-pas-nf1!newsfeed.earthlink.net!cyclone.socal.rr.com!cyclone2.kc.rr.com!news2.kc.rr.com!twister.socal.rr.com.POSTED!53ab2750!not-for-mail
From: Richard Kuhler <noone@nowhere.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: PL/SQL logical AND, OR, etc
Lines: 20
References: <89543c7c.0402021552.648515e3@posting.google.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
In-Reply-To: <89543c7c.0402021552.648515e3@posting.google.com>
Message-ID: <zfCTb.5272$Sv1.847@twister.socal.rr.com>
Date: Tue, 03 Feb 2004 00:50:39 GMT
NNTP-Posting-Host: 204.210.41.27
X-Complaints-To: abuse@rr.com
X-Trace: twister.socal.rr.com 1075769439 204.210.41.27 (Mon, 02 Feb 2004 16:50:39 PST)
NNTP-Posting-Date: Mon, 02 Feb 2004 16:50:39 PST
Organization: RoadRunner - West
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:135269

Stefan wrote:

> How can I do a logical AND or OR of BOOLEAN variables in PL/SQL??
> 
> Can I do this?
> 
> var1 BOOLEAN:=FALSE
> var2 BOOLEAN:=TRUE
> var3 BOOLEAN
> 
> var3:=var1 & var2  (so var3 would equal FALSE)

Should be ...

var3 := var1 and var2;


--
Richard Kuhler