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

Difference between truncate, delete and drop commands?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

What is the syntax to add a record to a table?

0 Answers  

---

What are the 3 types of behavioral triggers?

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

---

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

how to convert character strings to numeric values? : Sql dba

0 Answers  

---

Is join and inner join the same?

0 Answers  

---

What are the different types of a subquery?

0 Answers  

---

Where the sql database files are stored?

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---