Updating using explicit cursors Free sex chat with sexy girls without any login
Starting in Oracle10g, an Oracle bulk collect may be performed by the the PL/SQL engine for you.
The PL/SQL engine may automatically use Oracle bulk collect to collect 100 rows at a time because of a cursor loop.
When rows are retrieved using Oracle bulk collect, they are retrieved with only two context switches.
The larger the number of rows you would like to collect with Oracle bulk collect, the more performance improvement you will see using an Oracle bulk collect.
This use of Oracle bulk collect allows your code to process rows without having to setup and execute the Oracle bulk collect operation.
These loops can be used to process multiple rows in the cursor.
When there is more than one row in a cursor we can use loops along with explicit cursor attributes to fetch all the records.· We can fetch the rows in a cursor to a PL/SQL Record or a list of variables created in the PL/SQL Block.· If you are fetching a cursor to a PL/SQL Record, the record should have the same structure as the cursor.· If you are fetching a cursor to a list of variables, the variables should be listed in the same order in the fetch statement as the columns are present in the cursor.
Oracle provides some attributes known as Explicit Cursor Attributes to control the data processing while using cursors.
With Oracle bulk collect, the PL/SQL engine tells the SQL engine to collect many rows at once and place them in a collection.
During an Oracle bulk collect, the SQL engine retrieves all the rows and loads them into the collection and switches back to the PL/SQL engine.
The record locks are released when the next commit or rollback statement is issued.