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, 2168🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...