Answer / Deep Kumar Singh

A mutating error in PL/SQL occurs when a SQL statement modifies the same table as another SQL statement or PL/SQL block that is currently executing. This is not allowed because it can lead to inconsistent data. To avoid this, you should use implicit transactions or explicit BEGIN...COMMIT blocks.

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

What is pragma exception and how, when, where us

5 Answers  

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

how is myisam table stored? : Sql dba

1 Answers  

---

What is magic table?

6 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

Explain raise_application_error.

1 Answers  

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

What are the steps for performance tuning.

1 Answers  

---

How do you respond to dementia behavior?

1 Answers  

---