what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16824 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 transaction isolation levels supported by oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is dynamic proxy?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to fetch the row which has the max value for a column?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Explain implicit cursor.
What are the various oracle database objects?
What is an oracle transaction?
is there a tool to trace queries, like profiler for sql server?
How to bring a tablespace online?
How to increment dates by 1 in oracle?
Explain table?
How to connect the oracle server as sysdba?
11. Display the client number and name and the client number and name of the person who referred that client.
