SQL Plus - Set Null

Card Puncher Data Processing

About

Set null defines how nulls are displayed in a oracle result set :

set null text

Use the NULL clause of the COLUMN command to override the setting of the NULL variable for a given column. The default output for a null is blank (“”).

Reference





Discover More
Card Puncher Data Processing
Oracle Database - Null value (Missing Value)

SQL Null in the Oracle context. By default all columns allow NULL. Nulls are stored in the database and require 1 byte to store the length of the column (zero). Null is not aggregated and selected on...



Share this page:
Follow us:
Task Runner