Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between bulk collect and forall
- 3 Answers
- 27641 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / shweta singh
BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval
FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quickly.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are variables in pl sql?
What are functions in sql?
What is the use of count (*) in sql?
How does join work in sql?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Is merge a dml statement?
What is the difference between sql, mysql and sql server?
How can the performance of a trigger be improved?
Is pl sql a programming language?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How does postgresql compare to oracle/db2/ms sql server/informix?
Why is sql better than hql?
How bulk collect improves performance?
Explain commit, rollback and savepoint.
what is the difference between delete and truncate statement in sql? : Sql dba
