what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16821 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / anitha
select * from emp where null=null: will not return any rows
in the table since two null values are not always same.
select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.
| Is This Answer Correct ? | 36 Yes | 1 No |
Post New Answer View All Answers
What is partitioned table in Oracle?
How do you store pictures in a database?
What do you mean by cdb and pdb in oracle 12c?
What are the attributes of cursor?
How to write an inner join with the where clause in oracle?
How to upsert (update or insert into a table)?
Explain a segment?
How to pass parameters to procedures in oracle?
How to delete a column in an existing table?
What are the differences between blob and clob in oracle?
Describe varray?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is primefaces used for?
What is backup in Oracle?
What is rowid and rownum in oracle?
