Answer Posted / akn
Inner join is the most common type of join. Inner joins
return all rows from multiple tables where the join
condition is met.
Outer join returns all rows from one table and only those
rows from a secondary table where the joined fields are
equal (join condition is met).
Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What are the execution control statements?
How to open a cursor variable?
What are a query and state the different types of queries and their uses?
Write a syntax for update query in oracle?
How to specify default values in insert statement using oracle?
What is recovery manager(rman) backup in Oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is a connect identifier?
How to display employee records who gets more salary than the average salary in the department?
Use of an integrity constraint is better to validate data. Explain
What is oracle host variable?
Explain the use of Merge statement in oracle 11g
How to use "out" parameter properly?
What is a snapshot log?
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.