Search results
Learn how to use the Oracle CASE expression to add if-else logic to SQL statements without calling a procedure. See examples of simple and searched CASE expressions in SELECT, UPDATE, and HAVING clauses.
Learn how to use CASE expressions to perform IF ... THEN ... ELSE logic in SQL statements without procedures. See syntax, examples, and data type rules for simple and searched CASE expressions.
This Oracle tutorial explains how to use the Oracle / PLSQL CASE statement with syntax and examples. The Oracle / PLSQL CASE statement has the functionality of an IF-THEN-ELSE statement. Starting in Oracle 9i, you can use the CASE statement within a SQL statement.
Learn how to use the CASE statement to choose from a sequence of conditions and run a corresponding statement in Oracle Database PL/SQL. See syntax, semantics, examples, and related topics for simple and searched CASE statements.
Learn how to use the PL/SQL CASE statement to control the flow of a program. The CASE statement can be simple or searched and has an optional ELSE clause. See syntax, examples and comparison with CASE expression.
Learn how to use the CASE statement to choose from a sequence of conditions and execute a corresponding statement in Oracle Database SQL. See syntax, examples, and usage notes for simple and searched CASE statements.
7 gru 2023 · Learn how to use case expressions in Oracle SQL to implement IF-THEN logic in select, where, join, and PL/SQL. See simple and searched case expressions, key-value pairs, and performance tips.
