Home » SQL & PL/SQL » SQL & PL/SQL » CASE END
CASE END [message #190005] Tue, 29 August 2006 00:34 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi

Can we use CASE..END in PL/SQL?Give one example .
In which version of oracle it implements?

SAM
Re: CASE END [message #190012 is a reply to message #190005] Tue, 29 August 2006 01:01 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


 
syntax :

declare
begin
case when var1 then
dbms_output.put_line(...);
when .....

end case;
end;


regards,
Previous Topic: how to ungrant (get back) the permission. that we have given to one user.
Next Topic: sql script
Goto Forum:
  


Current Time: Thu Dec 05 00:39:32 CST 2024