IS NOT NULL in Oracle SQL PLSQL

In Oracle SQL / PLSQL IS NOT NULL is used to check whether the value of a literal IS NOT NULL or not. Example 1: Syntax to use IS NOT NULL in IF statement is: IF literal_name IS NOT NULL THEN <business_logic> END IF; Here if the literal_name does not have NULL value then the … Continue Reading

IS NULL in Oracle SQL PLSQL

In Oracle SQL / PLSQL IS NULL is used to check whether the value of a literal is NULL or not. Example 1: Syntax to use IS NULL in IF statement is: IF literal_name IS NULL THEN <business_logic> END IF; Here if the literal_name has NULL value then the IF condition will evaluate to TRUE, … Continue Reading

LIKE Condition in Oracle SQL -PLSQL

The LIKE condition in Oracle SQL / PLSQL is used in WHERE clause to place wildcard characters while fetching records. LIKE condition can be used with SELECT, INSERT, UPDATE and DELETE in SQL statements. LIKE condition have 2 flavors: 1. % – allows us to match string of any length including zero length. 2. _ … Continue Reading