Answer Posted / surendra reddy

Mutaing error happens with triggers. It occurs because the
trigger is trying to update a row it is currently using.
The usual fix involves either use of views or temporary
tables so the database is selecting from one while updating
the other.

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1003

---

What are secondary keys?

955

---

how to create a table index in mysql? : Sql dba

1035

---

Is full outer join same as cross join?

950

---

What is difference between left and right outer join?

966

---

What are sql ddl commands?

1073

---

What is sql indexing?

998

---

Mention what are different methods to trace the pl/sql code?

1177

---

How delete all data from all tables in sql?

930

---

what is not null constraint? : Sql dba

1005

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1151

---

Is sql considered coding?

1024

---

How do I create a memory optimized filegroup?

944

---

Describe different types of general function used in sql?

1016

---

What does select * from mean in sql?

3184

---