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 is system global area (sga) in oracle?
What is private procedure oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is a select query statement in oracle?
How to find out what oracle odbc drivers are installed?
How to use null as conditions in oracle?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
What is the difference between a primary key & a unique key?
What is oracle used for?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
What are a cluster and non-cluster index?