what is null value?
Answers were Sorted based on User's Feedback
Answer / ashu_deepu
most generally confuse the null value with zero.
but zero is different then null.
null can be understand as unknown value.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / mohit gupta
Null is a value that is unavailable, unassigned and unknown.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / guneetinder singh
Null is not a value but we can say it is unknown.
Is This Answer Correct ? | 4 Yes | 4 No |
Null value is that value which is neither zero or space or
any character.This value is defined by Oracle server, and
hence cannot be described.Also every null value generated
by server is unique than another..hence we cannot compare
it with character, numeric or date functions.
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / kuldeep singh
Null value is that value which is neither zero or space or
any character.null is not a value its just a concept to
avoid all values.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bharat_itstud
null value is a value i.e. unavalable, unknown & it is
equal to nothing.....
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sachin
A null value is not defined,applicable,available,known .
It can be a blank space or it can be a zero but it is not
equal to either zero or blank space......
Is This Answer Correct ? | 0 Yes | 1 No |
how to find the second highest salary in a given table????
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What WHERE CURRENT OF clause does in a cursor?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What are the benefits of ordbms?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
How remove data files before opening a database?
How can we find out the current date and time in oracle?
Explain enable novalidate constraint.
Difference between varchar and varchar2 data types?