what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 18041 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
Explain the difference between sap and oracle?
How to start your 10g xe server?
What is a sub query? Describe its types?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
how the indexes are stored in the Oracle Database?
Why we use bulk collect in oracle?
How to count groups returned with the group by clause in oracle?
How to get maxsal , minsal, ename department wise in single query
How can we force the database to use the user specified rollback segment?
Explain the blob datatype?
Explain oracle instance.
Explain what are the characteristics of data files?
How to create a table index in oracle?
What is Segment Advisor in Oracle?
How to convert characters to numbers in oracle?
