what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 17377 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
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
What is oracle and what are its different editions?
What is oracle rownum?
How do I manually create a database in oracle?
What is the oracle implicit cursor?
What is a sub query? What are its various types?
How to manage transaction isolation level?
How to connect ms access to oracle servers?
What is oracle server autotrace in oracle?
What is sequence?
What is bulk load in oracle?
Differentiate between post-database commit and post-form commit?
Respected sir, Please send me technical questions related to oracle apps..
What is a trigger and what are its types?
What is a system tablespace?
How do you find current date and time in oracle?
