what is the output of select * from emp where null=null &
select * from emp where 1=1
Answer Posted / anee desai
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;.if 2=2 will also provide the same
result.it makes no sense in writing 1=1;
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How do I know if oracle is installed on windows?
What is oracle sid?
How would you go about verifying the network name that the local_listener is currently using?
if you ctreate table identity
What is a data lock in oracle?
How to use null as conditions in oracle?
How to estimate disk space needed for an export job?
Explain mutating triggers.
How to enter a new row into a table interactively?
What are the logical operations?
What is literal?
how the indexes are stored in the Oracle Database?
How to do paging with oracle?
How do I limit the number of oracle database connections generated by weblogic server?
What is procedure overloading in oracle?