forum

home / developersection / forums / case when else in oracle sql

Ask Question
Utpal Vishwas

Student

I am Utpal Vishwas from Uttar Pradesh. Have completed my B. Tech. course from MNNIT campus Prayagraj in 2022. I have good knowledge of computer networking.

Follow
Can you answer this question?
Answer

1 Answers

Aryan Kumar

Aryan Kumar

18-Jul-2023

The CASE WHEN ELSE statement in Oracle SQL is a conditional statement that allows you to evaluate a condition and return a different result depending on the outcome of the evaluation. The CASE WHEN ELSE statement is a powerful tool that you can use to perform complex conditional logic in your SQL queries.

The syntax for the CASE WHEN ELSE statement is as follows:

SQL

CASE WHEN condition1 THEN result1
WHEN condition2 THEN result2
...
ELSE default_result
END;

The condition1, condition2, etc., are expressions that can be evaluated to a Boolean value. The result1, result2, etc., are the results that will be returned if the corresponding condition evaluates to TRUE. The default_result is the result that will be returned if none of the conditions evaluate to TRUE.

For example, the following CASE WHEN ELSE statement will return the grade of a student based on their score:

SQL

CASE WHEN score >= 90 THEN 'A'
WHEN score >= 80 THEN 'B'
WHEN score >= 70 THEN 'C'
WHEN score >= 60 THEN 'D'
ELSE 'F'
END;

If the student's score is greater than or equal to 90, then the CASE WHEN ELSE statement will return the letter grade A. If the student's score is greater than or equal to 80, but less than 90, then the CASE WHEN ELSE statement will return the letter grade B. And so on. If the student's score is less than 60, then the CASE WHEN ELSE statement will return the letter grade F.

The CASE WHEN ELSE statement is a powerful tool that you can use to perform complex conditional logic in your SQL queries. By using the CASE WHEN ELSE statement, you can write more concise and readable queries that are easier to understand and maintain.

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy