Case When Else in Oracle SQL

Utpal Vishwas 325 17 Jul 2023

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.

1 Answers

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.

forum

Case When Else in Oracle SQL

Can you answer this question?

1 Answers