Managing cursors, PL-SQL Programming

Managing Cursors

The PL/SQL uses 2 types of cursors: implicit and explicit. The PL/SQL declares a cursor implicitly for all the SQL data manipulation statements, including the queries which return only one row. Though, for queries which return more than one row, you should declare an explicit cursor or use a cursor FOR loop.

Posted Date: 10/4/2012 3:48:37 AM | Location : United States







Related Discussions:- Managing cursors, Assignment Help, Ask Question on Managing cursors, Get Answer, Expert's Help, Managing cursors Discussions

Write discussion on Managing cursors
Your posts are moderated
Related Questions
query to Find the account numbers of all customers whose balance is more than 10,000 $

The Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to t

Using LIMIT For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that yo

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Avoiding Collection Exceptions   In many cases, if you reference a nonexistent collection element, then PL/SQL raises a predefined exception. Consider the illustration shown b

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

FORALL Statement The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists

Explicitly specifying the join condition - SQL SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON ON ( IS_CALLED.StudentId = IS_ENROLLED_ON.StudentId ) Now, the key word JO

Updating Objects: To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows: BEGIN UPDATE persons p SET p