Answer / khaleek

There are only three type of joins
1) Equi Join
2) Non Equi Join
3) Cartesian Product or Cross Join.

Further Equi Join and Non Equi join can be divided into
following categories.
1) Inner Join
2) Outer Join
3) Self Join

Again Outer can be divide into following categories.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join

For detail please see at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

what is the command for user data type?

2 Answers  

---

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

how many ways to get the current time? : Sql dba

0 Answers  

---

Explain 3 basic parts of a trigger.

0 Answers  

---

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

How we can update the view?

0 Answers  

---

what is bdb (berkeleydb)? : Sql dba

0 Answers  

---

Why self join is used in sql?

0 Answers  

---

What is a database? Explain

0 Answers  

---

What is a data manipulation language?

0 Answers  

---