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 |
primary key is foreign key for the same table?
What is literal?
12. Display the client name in upper case only and in lower case only.
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
Explain oracle’s system global area (sga).
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
Why oracle is used?
Can we create trigger on materialized view in oracle?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Explain what are the uses of rollback segment?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad