What is forall Statement ?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ron
used in pl/sql block, to do bulk operations; to speed up
operations such as fetch and other dml statements.
Is This Answer Correct ? | 2 Yes | 0 No |
What are the execution control statements in oracle?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
What do you mean by merge in oracle and how can we merge two tables?
What is the difference between a user and a schema in oracle?
What is tns entry?
What is Hash Cluster ?
How to set a transaction to be read only in oracle?
Why packages are used in oracle?