Answer / ruchi

The keyword FORALL lets you run multiple DML statements
very efficiently. It can only repeat a single DML
statement, unlike a general-purpose FOR loop.

The FORALL statement issues a series of INSERT, UPDATE, or
DELETE statements, usually much faster than an equivalent
FOR loop. It requires some setup code, because each
iteration of the loop must use values from one or more
collections in its VALUES or WHERE clauses.

Answer / ron

used in pl/sql block, to do bulk operations; to speed up
operations such as fetch and other dml statements.

How to get last row id?

0 Answers  

---

How to run the anonymous block again?

0 Answers  

---

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

0 Answers   Oracle,

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

How do I recompile a procedure in oracle?

0 Answers  

---

What is integrity and what is constraint??Explain with example

0 Answers   Google,

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

what is the use of rank function?

1 Answers  

---

Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,

---

What is a server parameter file in oracle?

0 Answers  

---

What is DTS and purpose of DTS ?

1 Answers   TCS,

---