Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 19178 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada
Answer is below
Joins
a) Inner join or default join or Equi Join:
It selects all the matching aswellas non matching records
from both the tables.
b) Outer join: It selects all the matching
aswellas non matching records from both the tables
depending upon the join type.
1) Left outer join:
It selects all the records from the left table but only the
matching records from the right table.
2) Right outer join: It
selects all the records from the right table but only the
matching records from the left table.
3) Full outer join:
It’s a union of left and right outer join.
c) Cross join or Cartesian join: Every row
in the first table joins with every row in the second
table. It does not have any condition. It is also called as
a Cartesian join.
d) Self join: Joining a table by itself is
called Self join. Here we have to use alias table.
| Is This Answer Correct ? | 12 Yes | 24 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to create an oracle database manually?
Difference between open_form and call_form in oracle.
Give syntax for SQL and ORACLE joins.
what is the scenario where you take the database to NoArchivelog mode?
What is the database name in oracle?
What is an Oracle Instance?
Is oracle a relational database?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
6. Display the client name and order date for all orders using the traditional method.
Is there an oracle sql query that aggregates multiple rows into one row?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How many types of database triggers exist?
How to insert a record into a table?
How to rename a tablespace in oracle?
