Answer / a.jyothsna

1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join

Answer / desiraju venkata subramanya ka

types of joins
• outer join
• left join
• right join
• equi-join
• non-equi-join
• selfJoin

Answer / prakash

Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join

Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins

Answer / 123

cross join

What are different types of queries in sql?

1 Answers  

---

How do you define a foreign key?

1 Answers  

---

What are user defined functions?

1 Answers  

---

How to call shell script from pl sql procedure?

1 Answers  

---

What is not null in sql?

1 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

What is pragma in sql?

1 Answers  

---

What do you understand by pl/sql cursors?

1 Answers  

---

Does inner join remove duplicates?

1 Answers  

---

What is pessimistic concurrency control? : Transact sql

1 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

Write an sql query to select all records from the table?

1 Answers  

---