Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between bulk collect and forall
- 3 Answers
- 27753 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 we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is sql and also describe types of sql statements?
How does sql*loader handles newline characters in a record? : aql loader
What is having clause in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
What is write ahead logging in sql server?
What are joins in sql?
What is primary key and foreign key with example?
Why partition by is used in sql?
What is a pdo connection?
What is mdb stand for?
Explain some predefined exceptions.
What is constant in pl sql?
What is rownum?
What is sp_helptext?
