what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16867 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / bhavish
1.statament "no rows select"
2.statament "the 14 rows displayed
why because the true condition and null values are different
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is an oracle database table?
Explain the use of grant option in imp command.
How to upsert (update or insert into a table)?
When do you get a .pll extension in oracle? Explain its importance
Explain what are the uses of rollback segment?
How to insert a record into a table?
Explain parameter file in oracle.
What operating systems are supported by oracle database 10g xe?
Difference between inner join vs where ?
What is data type in oracle?
What is a package ? What are the advantages of package ?
What is a partition in oracle?
How can we create the complete backup of data in the oracle.
Briefly explain what is literal? Give an example where it can be used?
