Home » SQL & PL/SQL » SQL & PL/SQL » Retrieve Multiple result
Retrieve Multiple result [message #263431] Thu, 30 August 2007 01:06 Go to next message
ilangoraj
Messages: 5
Registered: August 2007
Junior Member
i had a senario like below example
Ex:

if low
low
low then "low"
else if low
low
High then "mixed"
else if
high
high
high then "high"

how to check in query wise


Re: Retrieve Multiple result [message #263433 is a reply to message #263431] Thu, 30 August 2007 01:18 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Sorry, but this is hardly understandable. provide create table and insert scripts along with what you have tried so far.
If you want to have a bash, have a look at decode or CASE
Re: Retrieve Multiple result [message #263449 is a reply to message #263431] Thu, 30 August 2007 01:59 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition,
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Weird problem :(
Next Topic: Create User/Schema
Goto Forum:
  


Current Time: Sat Dec 10 01:00:13 CST 2016

Total time taken to generate the page: 0.12472 seconds