what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 17381 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
Is the After report trigger fired if the report execution fails ?
How to rename an index?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to define an anonymous block?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to start a new transaction in oracle?
What is a system tablespace and when it is created?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is an oracle database table?
What's dateware house and what's clustor with practicle example
What do you mean by a deadlock?
What is the max number of columns in an oracle table?
How do I call oracle stored procedures that take no parameters?
How to bring a tablespace offline?
What is difference between cartesian join and cross join?
