Answer / monika

for loop is faster then open -fetch loop

Answer / nidhi

yes For Loop will be faster than the open fetch loop

Answer / swastik

yes for loop is faster tan loop-fetch
in loop there is exit statement to control the loop
in for loop it is an implicitly declared integer which is incremented or decremented by 1 until the upper bound or lower bound is reached

Answer / mihir kar

For loop is always faster than explicitly open -fetch loop.
the main advantages of for loop is it internally works like bulk collect limit 100
it hold 100 record and fetch so it is always preferebale.

Can a commit statement be executed as part of a trigger?

0 Answers  

---

Does sql require a server?

0 Answers  

---

Is sql a microsoft product?

0 Answers  

---

What is before trigger?

0 Answers  

---

Can a table contain multiple foreign key’s?

0 Answers  

---

What is pl/sql table? Why it is used?

0 Answers  

---

What is an intersect?

0 Answers  

---

What are sql constraints?

0 Answers  

---

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,

---

What are commit, rollback, and savepoint?

0 Answers  

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---