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
- 19323 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?
Is postgres faster than oracle?
Explain what are the type of synonyms?
How to use existing values in update statements using oracle?
Does oracle database need java?
How to use attributes of the implicit cursor in oracle?
How to export data with a field delimiter?
What are the set operators union, union all, minus & intersect meant to do?
Is a rollback possible to any savepoint?
How to select all columns of all rows from a table in oracle?
What is the disadvantage of User defind function?
How different is ms access and oracle?
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 are the attributes that are found in a cursor?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
