what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16910 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / samir kumar sahoo
select*from emp where null=null;
this command will not return any record bcoz the
condition null=null false as two null values are not equal.
select*from emp where 1=1;
will return all the records present in the table emp as
the condition 1=1 is always true.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to drop an index in oracle?
How to use select statement to count the number of rows in oracle?
What is the difference between a hot backup and a cold backup in oracle?
How does the on-delete-cascade statement work?
How do I connect to oracle database?
What is an oracle function?
Can select statements be used on views in oracle?
How to sort the query output in oracle?
What does sharding mean?
How to filter out duplications in the returning rows using oracle?
What are the major difference between truncate and delete?
Give the various rollback segment states.
What is a proxy object?
Can you tell me how to add new column in existing views?how?How is possible?
How to define and use table alias names in oracle?
