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, 1619🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...