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 […]
condition
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, […]
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. _ […]
EXISTS Condition in Oracle SQL – PLSQL
The EXISTS condition in Oracle SQL / PLSQL will return any records whenever the “exists” condition is met. EXISTS condition can be used with SELECT, INSERT, UPDATE and DELETE SQL statements. Syntax for the EXISTS condition in Oracle SQL / PLSQL is: SELECT column_name(s) FROM table_name WHERE EXISTS (subquery); Or INSERT INTO table_name VALUES(column_name1 ,column_name2 […]
BETWEEN Condition in Oracle SQL – PLSQL
The BETWEEN condition in Oracle SQL / PLSQL allows us to filter the records within a range of values including values provided for the range. BETWEEN condition can be used with SELECT, INSERT, UPDATE and DELETE SQL statements. Syntax for the BETWEEN condition in Oracle SQL / PLSQL is: SELECT column_name(s) FROM table_name WHERE column_name […]