Thread: null

how i can verifiy the null occupied the memory...

Originally Posted by deepakbit2

how i can verifiy the null occupied the memory...

NULL is absence of value. How can a non existent value occupy space in memory?

Code:

SQL> CREATE TABLE TEST_DATA( X NUMBER);

Table created.

SQL> INSERT INTO TEST_DATA VALUES(NULL);

1 row created.

SQL> SELECT DUMP(X) FROM TEST_DATA;

DUMP(X)
--------------------------------------------
NULL

null does not occupy any memory.