what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 18140 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / raj
Null=Null returns no row but 1=1 returns entire row of the
table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to define an explicit cursor in oracle?
How to write a left outer join with the where clause in oracle?
How to speed up webrick?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to call a sub procedure?
How do I spool in oracle?
How a tablespace is related to data files?
What is oracle update statement with inner join ?
how to join query for one source type is oracle another source type is sql server ?
Why oracle is used?
Can sub procedure/function be called recursively?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What happens if the update subquery returns multiple rows?
What are triggers in oracle?
