Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 19294 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 is varray?
Can we save images in a database and if yes, how?
What is query image?
What is a procedure in oracle?
State any two functions of oracle?
What are ddl statements in oracle?
Explain an integrity constrains?
How to loop through a cursor variable?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What the is the diff between local index and global index. give some example.
How do I manually create a database in oracle?
How to update values on multiple rows in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
