Storage of Null Values

citrix training courses malaysia

null is the absence of a value in a column. Nulls indicate missing, unknown, or inapplicable data.

isaca certification training courses malaysia

Nulls are stored in the database if they fall between columns with data values. In these cases, they require 1 byte to store the length of the column (zero). Trailing nulls in a row require no storage because a new row header signals that the remaining columns in the previous row are null. For example, if the last three columns of a table are null, then no data is stored for these columns.

dell emc training courses malaysia

See also

Oracle Database SQL Language Reference to learn more about null values

comptia training courses malaysia

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *