OraFAQ Forum: SQL & PL/SQL » case statement

Home » SQL & PL/SQL » SQL & PL/SQL » case statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

case statement [message #41176]

Wed, 04 December 2002 08:39

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

i have code

declare
a number;
begin
a:=&a;
case a
when 1 then dbms_output.put_line('case 1');
when 2 then dbms_output.put_line('case 2');
else
dbms_output.put_line('case else');
end case;
/
the above code give error
please help

Report message to a moderator

Re: case statement [message #41178 is a reply to message #41176]

Wed, 04 December 2002 11:09

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

CASE is a part of SQL and is not a PL/SQL construct. You will need to use IF/ELSIF/ELSE/END IF to handle this:

if a = 1 then
  dbms_output.put_line('case 1');
elsif a = 2 then
  dbms_output.put_line('case 2');
else 
  dbms_output.put_line('case else');
end if;

Report message to a moderator

Previous Topic:	invalid cursor???
Next Topic:	Accessing Package.procedure across database links

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 01:58:42 CDT 2024