Case

From: Ofer Harel <oharel_at_barak013.net.il>
Date: Tue, 27 May 2003 01:39:39 -0800
Message-ID: <F001.005A2F97.20030527013939@fatcity.com>

Good morning,

suppose I want to make this code in a procedure: t1 & t2 are records in the procedure

   if t1.a=1 then t2.x=t2.x+1;;
   elseif t1.a=2 then t2.y=t2.y+1;
   elseif.....
   end if;

is there a better way, can it be done in case expression?

Ofer
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ofer Harel
  INET: oharel_at_barak013.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 27 2003 - 04:39:39 CDT