Interested to Buy Any Domain ? << Click Here >> for more details...
what is null value?
- 11 Answers
- 16423 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 do you increase the OS limitation for open files (LINUX and/or Solaris)?
Find all employees in Dept “Marketing”.
What is the difference between 10g OEM and 11g OEM?
How to create a new table in oracle?
How to use subqueries with the in operator using oracle?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
How to put more than 1000 values into an oracle in clause?
what is load balancing and what u have used to do this?(sql loader)
Explain index?
How to use an explicit cursor without open statements?
how to retrive xml data for using sql query?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
Oracle General 
