Collections:
What Is NULL in PL/SQL in Oracle
What Is NULL in PL/SQL in Oracle?
✍: FYIcenter.com
NULL is a reserved key word and it stands for two things in PL/SQL:
The following sample script shows you examples of using NULL keyword:
DECLARE next_task CHAR(80); BEGIN next_task := NULL; -- NULL value 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; -- NULL statement ELSE DBMS_OUTPUT.PUT_LINE('... working on ' || next_task); END IF; END;
This script should print this:
I am free.
⇐ Use "FOR" Loop Statements in Oracle
2018-07-13, 1638🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...