rahultripathi

 Profile Answers by rahultripathi 

• Sep 28th, 2005

 

The NULL in C treated as Zero or void. but in SQL NULL value is Non or blank represented it can't manuplated

Sampath

• Oct 22nd, 2005

 

NULL in SQL in an unknown value. It neither zero nor any valid value. It cannot be mapulated, but it can only be compared

geostar365

• Dec 14th, 2005

 

With reference from the Oracle book,NULL is a undetermined value and will lead to infinite process (loop). NULL must be handled carefully to avoid ambiguity.To understand the difference, ZERO is a numeric value and BLANK is a special character.All the best!!!

Ritesh Raj Singh Oracle DBA GKPL Mumbai

• Feb 8th, 2006

 

Null in C is Nothing or Void which can be compared with normal operators but inoracle Null can't be compared with normal operators like '=' or greater than or smallerthan.so be careful in using this feature of oracle because it can lead to several problems as like if u compared a password with oracle internal password and a user supplies a nullin password ur comparison may false like if INPUT_PASSWORD<>ORIGINAL_PASSWORD then raise_application_error(-20225,'"Incorrect Password"); end ifHope it may clear the DoubtsRitesh Raj SinghOracle DBA GKPL Mumbaivisit me atwww.oracledba.co.nr

Ashish

• Sep 7th, 2006

 

The "NULL" in C means zero or void.Also its something that is uniform across the C program.In Oracle though,you cant even compare two "NULL" values to be equal.NULL in oracle means nothing or no value.

Vishal Verma

• Dec 19th, 2006

 

Nulls can be compared in Oracle

1) Select 1 from dual where null is null;

- results 1

2) select 1 from scott.emp where ename is null

- if ename is null, results 1 will be output

ravi.8311

 Profile Answers by ravi.8311 

• Jun 15th, 2008

 

in oracle null is a undefined value,something value is there dut we can not manipulated it. in c null is a zero or any valid data

sesindia

 Profile Answers by sesindia 

• Nov 13th, 2008

 

in c null may take the grabage values also
but in orcale it means if no data available at this column accept it ,
it is like a constrient

symhdl

 Profile Answers by symhdl 

• Jan 2nd, 2009

 

This is not truely the right answer.

When you store data in oracle its terminated with a zero byte. 

For example when you store HELLO its stored as 

5HELLO where is the zero byte. When you dont store any data specifically or when the variable is null it contains zero byte stored in 2byte length indicator

In other words null is still a zero byte data stored in 2bytes.

Example. - . 

Null in C is not garbage value that is a misconception. Null in C also is a zero byte character - null character, ''

If the variable is not initialized the location may contain some values which could be considered as garbage as its unpredictable.

 

 

 

zelani

 Profile Answers by zelani 

• Jan 12th, 2009

 

null in c is some garbage value which cannot be predicted . If you are not intialising any value to the variable then null value is present in auto variables.
null in oracle is used in sql queries for getting values whose values are null such as manger is null or comm is null.the null is an operator in oracle . If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "<>" against NULL.