What is diff between bulk collect and forall
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 is the difference between char and varchar data types? : Sql dba
Can we rollback truncate?
What are its different types of dbms?
How long will it take to learn pl sql?
What is difference between primary and secondary key?
Is sqlite thread safe?
Write a sql query to convert all character to uppercase after hypen.
What is sql*loader and what is it used for? : aql loader
Which query operators in sql is used for pattern matching?
Is left join same as inner join?
Which is better join or subquery?
Can we rollback after truncate?
Can we join more than 2 tables in sql?
What does the sign mean in sql?
How does sql developer connect to oracle database?