what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 17383 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / chandana
NULL = NULL ...NOT TRUE
NO ROWS RETURNED
1=1 ...TRUE
ALL ROWS RETURNED
1=2....NOT TRUE
NO ROWS RETURNED
2=2,3==3 AND SO ON WILL RETURN ALL ROWS FROM A TABLE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the parameters that we can pass through a stored procedure?
What is the max number of columns in an oracle table?
What is a procedure in oracle?
What is the usage of synonyms?
How can we view last record added to a table?
How to end the current transaction in oracle?
Write a trigger example in oracle?
6. Display the client name and order date for all orders using the traditional method.
How to do clean up if create database failed?
What is the difference between online and offline backups?
Explain do view contain data?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is difference between sid and service name in oracle?
what is the scenario where you take the database to NoArchivelog mode?
How to empty your oracle recycle bin?
