Answer / sudhakar naraparaju

It depends on the number of records being looped. If it is
a huge table then it is better to commit after a specific
number of transactions are completed. Even better to do
inside the loop so that the data is commited for every set
looped.

Answer / anil_abbireddy

End of the Block

Answer / kalyan maddipati

We can use savepoint. This transactional control statement
can be used to save records at perodic intervals

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

---

What are functions in sql?

0 Answers  

---

what is cross join? : Sql dba

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

---

what are the different tables present in mysql? : Sql dba

0 Answers  

---

How many databases can sql express handle?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

Which data type is a composite type?

0 Answers  

---

how to saw triggers output in pl/sql database?

1 Answers  

---

How do rank () and dense_rank () differ?

0 Answers  

---

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

---