what is the output of select * from emp where null=null &
select * from emp where 1=1
Answer Posted / shree
first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
20. Using a set operator, display the client number of all clients who have never placed an order.
what is reindexing?
What is sharded cluster?
How to count groups returned with the group by clause in oracle?
Are truncate and delete commands same? If so why?
Explain database link?
What is the disadvantage of User defind function?
How to drop an existing view in oracle?
How do I uninstall oracle 11g?
Differentiate between post-database commit and post-form commit?
How to pass a cursor variable to a procedure?
How data locks are respected in oracle?
How is it different from a normal table?
Whats the benefit of dbms_stats over analyze?
What is partitioned table in Oracle?