Interested to Buy Any Domain ? << Click Here >> for more details...
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2
OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE
SAME THEN WHAT IS THE USE OF OUTER JOINS.
- 1 Answers
- 6753 Views
- Syntel, I also Faced
- E-Mail Answers
Answer / ravi
Simple joins gives only matching/common values from two or
more tables
If you have mentioned only Outer joins then it is same as
simple join gives the matching values from two or more
tables but outer joins are of two types--- right outer join
and left outer join
for right outer join--- it will give non matching rows also
from right table in addition to matching rows
for left outer join-- it will give non matching rows also
from left table in addtion to matching rows
| Is This Answer Correct ? | 13 Yes | 0 No |
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Mention the various locks that are available in db2.
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What does DML stand for and what are some examples of it?
Name the different types of Table spaces.
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How do you Load a table ?? and what is Load replace ?
What is the result of open cursor statement?
Why might full image copies be faster to implement than an incremental image copy?
How to access db2 tables in mainframe?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
COBOL 
