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 is spool?

0 Answers  

---

What is pls_integer in pl sql?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

What is meant by cursor in sql?

0 Answers  

---

Why do you partition data?

0 Answers  

---

Is oracle sql free?

0 Answers  

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

Why do we use sqlite?

0 Answers  

---

Can a foreign key have a different name?

0 Answers  

---

What is an example of translating a date into julian format?

0 Answers  

---