Home » SQL & PL/SQL » SQL & PL/SQL » can we write a "SWITCH" statement in PL/SQL block?
icon14.gif  can we write a "SWITCH" statement in PL/SQL block? [message #263275] Wed, 29 August 2007 10:17 Go to next message
pvannapurna
Messages: 8
Registered: October 2006
Location: Hyderabad
Junior Member
No Message Body
Re: can we write a "SWITCH" statement in PL/SQL block? [message #263282 is a reply to message #263275] Wed, 29 August 2007 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is named CASE.

Regards
Michel
Re: can we write a "SWITCH" statement in PL/SQL block? [message #263283 is a reply to message #263275] Wed, 29 August 2007 10:38 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Didn't you get a chance to look at the Forum Guide?

Anyway are you looking for "CASE"? Otherwise you can write IF - ELSE tree.

By
Vamsi
Previous Topic: SQL query with the parameters substituted
Next Topic: What is the difference primary key and unique key with not null constraint
Goto Forum:
  


Current Time: Mon Dec 05 19:28:51 CST 2016

Total time taken to generate the page: 0.13865 seconds