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

How can I get the number of records affected by a stored procedure?

0 Answers  

---

Are sql connections encrypted?

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

How do I trace sql profiler?

0 Answers  

---

What is dialect in sql?

0 Answers  

---

What is informix sql?

0 Answers  

---

What is gpt format?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How do you go back in sql?

0 Answers  

---

Is clustered index a primary key?

0 Answers  

---

Define commit, rollback and savepoint?

0 Answers  

---