What is diff between bulk collect and forall
- 3 Answers
- 26508 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
Can you inner join the same table?
Why do we use %rowtype & %type in plsql?
what is sql? : Sql dba
What is normalization in a database?
How do I run sql?
what are set operators in sql? : Sql dba
What are different types of statements supported by sql?
What does count (*) mean in sql?
What is data manipulation language?
What is dynamic query?
What are the benefits of pl sql?
can sql servers linked to other servers like oracle? : Sql dba
Is inner join faster than left join?
describe mysql connection using mysql binary. : Sql dba
What is a natural join?
