Re: CASE strucrure in PL/SQL

• Original Message ----- From: "Rob Cowell" <rjc4687_at_hotmail.com> Newsgroups: comp.databases.oracle.server Sent: Wednesday, June 04, 2003 9:09 AM Subject: Re: CASE strucrure in PL/SQL
  :
  : Onismus Radebe wrote:
  : >
  : > Is CASE strucrure supported in PL?
  : >
  :
  : Did you guess that syntax or look it up in the manual?
  :
  :
  http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96624/13_elems 5.htm#36890
  :
  : LOOP
  : CASE i
  : WHEN 1 THEN v_department_id := 10
  

Bob I got the syntax from a Student Guide for Oracle 9i and the server that I'm using is 8i I think that might be the reason causing all of this. I could have used the IF structure because I'm lazy to type I decided to use CASE. We 'll be moving to Oracle 9i in a month until then I 'll have to use the IF --- THEN ---ELSIF---ELSE---END IF structure.

--
Onismus