Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
currval and nextvalthe series is a schema object which generates the sequential numbers whenever you form a sequence you can specify its primary
sql pseudocolumnsthe plsql recognizes the following sql pseudocolumns that returns the specific data items level nextval currval rowid amp rownum the
sql functionsthe plsql uses all the sql functions involving the following aggregate functions that summarize the whole columns of the oracle data
transaction controlthe oracle is transaction oriented that is oracle uses the transactions to make sure the data integrity the transaction is a
referencing recordsunlike the elements in a collection that are accessed using subscripts the fields in a record are accessed by name to reference an
initializing recordsthe illustration below shows that you can initialize a record in its type definition whenever you declare a record of the type
declaring recordswhenever you define a record type you may declare records of that type as the illustration showsdeclaretype stockitem is record
defining and declaring recordsto create records you have to define a record type and then declare records of that type you may also define record
what is a record a record is a group of related data items that stored in the fields each with its own name and datatype assume that you have
using cursor attributesto process the sql data manipulation statements the sql engine must opens an implicit cursor named sql this cursors attributes
using host arraysthe client-side programs can use anonymous plsql blocks to bulk-bind input and output host arrays however this is the well-organized
using forall and bulk collect togetheryou can unite the bulk collect clause with the forall statement in that case the sql engine bulk-binds column
bulk fetchingthe illustration below shows that you can bulk-fetch from a cursor into one or more collectionsdeclaretype nametab is table of
using the bulk collect clausethe keywords bulk collect specify the sql engine to bulk-bind output collections before returning them to the plsql
rollback behaviorwhen a forall statement fails the database changes are rolled back to an implicit savepoint marked before each of the sql statement
using the forall statementthe keyword forall instruct the plsql engine to bulk-bind input collections before sending them all to the sql engine
how bulk binds improve performancethe assigning of values to the plsql variables in sql statements is known as bindingthe binding of the whole
using deletethis process has three forms the delete removes all elements from the collection deleten removes the nth element from the nested table
using trimthis process has two forms the trim removes an element from the end of the collection the trimn removes the n elements from the end of the
using extendto enlarge the size of a collection use extend this process has 3 forms the extend appends one null element to a collection and the
using prior and nextthe priorn returns the index number that precede index n in a collection the nextn returns the index number which succeed the
using first and lastfirst and last return the first and last minimum and maximum index numbers in a collection when the collection is empty the first
using limitfor nested tables that have no maximum size the limit returns null for varrays the limit returns the maximum number of elements that a
using countthe count returns the number of elements that a collection presently contains for instance when a varray projects contains 15 elements
using existsthe existsn returns true if the nth element in a collection exist or else existsn returns false primarily you use exists with delete to