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, 2172🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...