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: 65135
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: 2108
Registered: October 2003
Location: Hyderabad, India
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: Wed Aug 16 20:55:07 CDT 2017

Total time taken to generate the page: 0.06382 seconds