What is the result, when NULL is compared with NULL?

Answer Posted / kirankumar.vangeti

Null is neither equal to null nor it is not equal to null.
Any comparison to null is evaluated to null.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are its different types of dbms?

525


Are stored procedures faster than queries?

512


Is full outer join same as cross join?

493


Does oracle use sql?

500


Why do we need view in sql?

538






What pl/sql package consists of?

624


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

1896


What is the order of sql select?

559


how to rename an existing column in a table? : Sql dba

498


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1708


How to use sql statements in pl/sql?

566


What is sql character function?

535


What is a field in a database?

555


What is restrict in sql?

546


Are pl sql variables case sensitive?

586