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 Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

How do you declare a variable in pl sql?

0 Answers  

---

write a query to display diference between two dates in sql server

2 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

What is crud diagram?

0 Answers  

---

Which command is used to delete a package?

0 Answers  

---

Is sql a programming?

0 Answers  

---

How do you know if a relationship is 2nf?

0 Answers  

---

What is coalesce in sql?

0 Answers  

---