Search results
The IF statement either runs or skips a sequence of one or more statements, depending on the value of a BOOLEAN expression. ( boolean_expression ::= , statement ::= ) Expression whose value is TRUE, FALSE, or NULL. The first boolean_expression is always evaluated.
This tutorial shows you how to use the PL/SQL IF statement to either execute or skip a sequence of statements based on a specified condition.
Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Start learning SQL now » Examples in Each Chapter
After completing this series, you will have the ability to write complex SQL statements to query data and manage database objects. This tutorial series is practical; therefore, you’ll need access to an Oracle Database 12c or later for hands-on exercises and proofs of concept.
The Oracle basics section teaches you about how to use SQL to interact with the Oracle database. You will learn various techniques to query data from the database and how to manage database tables such as creating, modifying, and deleting tables.
This Oracle tutorial explains how to use the IF-THEN-ELSE statement in Oracle with syntax and examples. In Oracle, the IF-THEN-ELSE statement is used to execute code when a condition is TRUE, or execute different code if the condition evaluates to FALSE.
There are three forms of IF statements: IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSIF. The simplest form of IF statement associates a Boolean expression with a sequence of statements enclosed by the keywords THEN and END IF. The sequence of statements is executed only if the expression returns TRUE.
