Answer Posted / sandeep verma

Join match/combine two or more tables from a database. It means, combining rows or fields of two or more tables matching the common values. There are various types of joins which are as follows:
a) Self Join: joining table with it's own record to extract unique record (one employee is manager of other two employee)
b) Inner Join
i) Equi Join:No difference with inner join (just write join instead of inner join)
ii) Cross Join: will get you result each row of first table with each row of the other table(i.e. select * from employee cross join salary)
c) Outer Join
i) Left Outer Join:joins the matching records from two tables and all the records from left side of the table and those unmatched records have null value in right side of the table.
ii) Right Outer Join:joins the matching records from two tables and all the records from right side of the table and those unmatched records have null value in left side of the table.
iii) Full Outer Join: Regardless of matching record of both side of the tables, it produce all the records of both the table and produce NULL values for every column of the table that lacks of matching row.

What is varray in pl sql?

1069

---

What is dialect in sql?

942

---

How do I run a sql trace?

957

---

What is the difference between a subquery and a join?

1098

---

define sql delete statement ? : Sql dba

1015

---

What is string data type in sql?

1137

---

What are the two types of periodical indexes?

936

---

What is bind reference and how can it be created?

1015

---

Why do we need cursors in pl sql?

1076

---

Is it possible for a table to have more than one foreign key?

1030

---

What is integrity in sql?

1039

---

How can I see all tables in sql?

1066

---

what is the syntax used for partition in tsql? : Transact sql

1014

---

How many scalar data types are supported in pl/sql?

1054

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

1026

---