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, 1594🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...