Cursors - syntax, PL-SQL Programming

Cursors 

To execute the multi-row query, the Oracle opens an unnamed work region which stores the processing information. The cursor names the work region, access the information, and then process the rows separately.

Syntax:

525_cursor syntax.png

1540_cursor syntax1.png

Posted Date: 10/8/2012 5:54:29 AM | Location : United States







Related Discussions:- Cursors - syntax, Assignment Help, Ask Question on Cursors - syntax, Get Answer, Expert's Help, Cursors - syntax Discussions

Write discussion on Cursors - syntax
Your posts are moderated
Related Questions
What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

Keyword & Parameter Description: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This

Using COMMIT The COMMIT statements end the present transaction and make permanent any changes made during that transaction. Till you commit the changes, other users cannot acc

EXIT Statement   You can use the EXIT statement to exit a loop. The EXIT statement has 2 forms: the conditional EXIT WHEN and the unconditional EXIT. With the either form, you

query to Find the account numbers of all customers whose balance is more than 10,000 $

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is

Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla

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

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s