Collections:
Test NULL Values in Oracle
How To Test NULL Values in Oracle?
✍: FYIcenter.com
There ate two special comparison operators you can use on NULL values:
The following sample script shows you examples of comparing NULL values:
DECLARE next_task CHAR(80); BEGIN next_task := NULL; IF next_task IS NOT NULL THEN DBMS_OUTPUT.PUT_LINE('I am busy.'); ELSE DBMS_OUTPUT.PUT_LINE('I am free.'); END IF; IF next_task IS NULL THEN NULL; ELSE DBMS_OUTPUT.PUT_LINE('... working on ' || next_task); END IF; END;
Note that "variable = NULL" is not a valid operation. This script should print this:
I am free.
⇒ Creating Oracle PL/SQL Procedures and Functions
⇐ What Is NULL in PL/SQL in Oracle
2018-07-13, 1613🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...