Answer / kiran r

An Exception is error handling part when ever error occurs exception raises.
Exceptions are classified as
1. Predefined Exception
2.User defined exception
some of predefined Exceptions are:
NO DATA FOUND, TOO MANY ROWS, CURSOR ALREADY OPEN, INVALID CURSOR, INVALID NUMBER, ZERO DIVIDED

What are the features of pl sql?

0 Answers  

---

what is HASH join?

2 Answers   Genpact, HCL,

---

What is clustered and nonclustered index in sql?

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

---

What is composite data type in pl sql?

0 Answers  

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

What is a left join?

0 Answers  

---

What is trigger and stored procedure in sql?

0 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

What is pl/sql tables?

7 Answers   TCS,

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---