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

can i call procedure in package

3 Answers   TCS,

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

How do I run pl sql in sql developer?

0 Answers  

---

---

Can a key be both primary and foreign?

0 Answers  

---

What is sqlca in db2?

0 Answers  

---

What is trigger and stored procedure in sql?

0 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

Explain constraints in sql?

0 Answers  

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

What is difference between sql and mysql?

0 Answers  

---