Case When Else in Oracle SQL

Utpal Vishwas 425 17 Jul 2023

Ask by Utpal Vishwas

Updated 18 Jul 2023

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.

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Case When Else in Oracle SQL

Can you answer this question?

1 Answers