Interested to Buy Any Domain ? << Click Here >> for more details...
What is forall Statement ?
- 2 Answers
- 5959 Views
- Thermotech, I also Faced
- E-Mail Answers
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 |
The join defined by the default data link is an outer join yes or no ?
Explain constraining triggers.
Explain about your project and its relation to the current job position you are applying to?
How to open and close an explicit cursor in oracle?
What is an oracle data file?
Can we write insert statement in function in oracle?
What do you mean by a deadlock?
What are the general rules on data consistency?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
What is use of oracle?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
How to sort the query output in oracle?
Oracle General 
