Interested to Buy Any Domain ? << Click Here >> for more details...
what is null value?
- 11 Answers
- 16735 Views
- KITS, Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ruchi singh
null is a value that is unknown , unavailable or
inapplicable. Null is not same as zero or blank space.
| Is This Answer Correct ? | 48 Yes | 4 No |
Answer / pr@$@d
Null means unknown value
The value null can be regarded as an unknown value.
Therefore, the following select statement returns null:
select 5+7+null+9 from dual;
Note : A null can be assigned but it can not be equated
with anything: Even itself.
Regards,
-Pr@$@d.
prasadreddi@ymail.com
| Is This Answer Correct ? | 18 Yes | 3 No |
1.It is undefined and uncomparable value.
2.It is not equal to 0 and SPACE.
3.It will not occupy any MEMORY.
4.It has to be supported by every RDBMS package to have
unique treatment for all data types.
5.Any arithematic operations with null returns a null value.
6.It represents with "NULL" keyword and display a space.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / purushotham
Null is an inapplicable or blank which is not equal to too.
null along with any operator results in NULL Except
concatenation.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / anilchauhan85
null value means null it it not equal 0 or space.
if we add,delete,subtract in null then return null.
ex.
1+2+null=null
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / ela tiku
Null Value is neither zero nor it is a blank space. It is
some unknown value which occupies 4 bytes of space of
memory in SQL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sridhark
NUll means 'UNknown' or 'Missing value' or 'Not known'
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kannan
Null value is unknown, unavailable .
NUll is not equal to Zero or Space .
Null is not equal to another Null value.
Null value can be assigned to variable or attributes (any
datatypes)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ela
Null is not eqal to zero not is an empty space. it is
simply comprising of 4 bytes of unknown value.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to define an oracle cursor variable?
How to start a new transaction in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is a nvl function? How can it be used?
How to upsert (update or insert into a table)?
How to resolve name conflicts between variables and columns?
Explain integrity constraints?
What is snapshot is too old? Give and example for better understand.
Is insert autocommit in oracle?
How to connect to the server with user account: sys?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
What are the predefined tablespaces in a database?
Oracle General 
