What is forall Statement ?
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 |
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Describe the types of sub query?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Where do we use decode and case statements?
How do I uninstall oracle client from windows?
How to connect ms access to oracle servers?
what is the difference between rollback & commit? can a foreign key has null value?
How to convert characters to dates in oracle?
How many anonymous blocks can be defined?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
when do u go for hash partitioning?