Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
use serially reusable packagesto help you to manage the use of memory the plsql gives the pragma serially reusable that mark some packages as
use the returning clausefrequently the application requires information about the row affected by a sql operation for illustration to produce a
use the nocopy compiler hintby default the out and in out parameters are passed by the value ie the value of an in out actual parameter is copied
use external routinesthe plsql is particular for the sql transaction processing therefore several tasks are more quickly completed in a lower-level
use native dynamic sqla few programs a normal-purpose report writer for illustration should build and process a variety of sql statements at run time
use bulk bindsif sql statements execute inside a loop using the collection elements as bind variables context switching between the plsql amp sql
use object types and collectionsthe collection types and object types increase your efficiency by allowing for the realistic data modeling the
using savepointsthe scope of the savepoint is a transaction in which it is defined the savepoints defined in the major transaction are not related to
entering and exitingif you enter the executable part of an autonomous routine the major transaction suspends when you exit the routine the major
controlling autonomous transactionsthe first sql statement in an autonomous routine starts a transaction whenever one transaction ends the next sql
autonomous versus nested transactionsthough an autonomous transaction is started by the other transaction it is not a nested transaction for the
defining autonomous transactionsto define an autonomous transaction you use the pragma compiler directive autonomoustransaction the pragma instructs
fetching across commitsthe for update clauses acquire exclusive all row locks all rows are locked when you open the cursor and when you commit your
using lock tableyou use the lock table statement to lock the whole database tables in the specified lock mode so that you can share or deny the
using for updateif you declare a cursor which will be referenced in the current of clause of an update or delete statement you should use the for
overriding default lockingby default the oracle locks the data structures for you automatically though you can request exact data locks on rows or
using set transactionyou use the set transaction statement to begin the read-only or read-write transaction start an isolation level or assign your
ending transactionsa good quality programming practice is to commit or roll back every transaction explicitly whether you rollback or issue the
implicit rollbacksbefore execute the insert update or delete statement the oracle marks an implicit savepoint when the statement fails the oracle
using savepointthe savepoint names and marks the present point in the processing of a transaction used with the rollback to statement the savepoints
using rollbackthe rollback statements end the present transaction and undo any change made during the transaction the rolling back is helpful for two
using committhe commit statements end the present transaction and make permanent any changes made during that transaction till you commit the changes
how transactions guard your databasethe transaction is a sequence of sql data manipulation statements which does a logical unit of work the oracle
processing transactionsthis part describes how to do the transaction processing you learn the fundamental techniques that safeguard the consistency
rowcountthe rowcount yields the number of rows affected by the insert update or delete statement or returned by a select into statement the rowcount