From: Breno de Avellar Gomes <brenogomes@ieee.org>
Subject: Re: Switch, select case, etc.
Date: 2000/07/07
Message-ID: <39665439.61283E4@ieee.org>#1/1
Cache-Post-Path: osiris.esoterica.pt!unknown@por339.esoterica.pt
Content-Transfer-Encoding: 8bit
References: <4Sr95.345$Rz1.1174@news1.mts.net>
X-Accept-Language: en
Content-Type: text/plain; charset=iso-8859-1
X-Complaints-To: usenet@news.interpacket.net
X-Trace: news.interpacket.net 963007538 66129 209.198.242.35 (7 Jul 2000 22:05:38 GMT)
Organization: Arquivo-Sistemas de Bases de Dados
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Mime-Version: 1.0
Reply-To: brenogomes@ieee.org
NNTP-Posting-Date: 7 Jul 2000 22:05:38 GMT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools


Use if..elsif..else
It acts as C switch..case..default

mAd hAcker wrote:
> 
> Is there a switch, or select case type statement in PL/SQL?  Or do I have to
> use if..elsif..elsif..???
> 
> --

-- 
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ---------------------------------------------------- 

Breno de Avellar Gomes 
Database Applications & Internet Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
EC Municipio
4017-001 Porto
Portugal

brenogomes@ieee.org
Cellular phone: 351-917383469
Cellular messages: 917383469@sms.telecel.pt
ICQ # 35567342

Toll free fax and answering machine from USA
1-888-EXCITE2  extension  291-303-8152

Outside USA (international fares apply)
1-917-463-3173