null

deepakbit2 · #1 (**permalink**) 07-03-2008

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

krishnaindia2007 · #2 (**permalink**) 07-04-2008

Quote:

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

debasisdas · #3 (**permalink**) 07-04-2008

null does not occupy any memory.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Null V Nothing	dubdownunder	SQL	5	03-27-2008 06:46 AM
null statement in c	ShrutiS	C and C++	6	03-18-2008 09:41 AM
Set columns as not null	jency	SQL	2	12-06-2007 01:12 AM
Not null constraint	Geek_Guest	SQL Server	2	10-17-2007 07:05 AM
Built-in and plugin stages, Chaning Null to Not Null and Types of lookup	Geek_Guest	Data Warehousing	0	04-06-2007 04:48 AM

null

null

Similar Threads