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
Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

Wrapping and unwrapping in SQL Operators WRAP and UNWRAP in connection with attributes whose declared types are tuple types. Example shows how extension and projection can be

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

a. Write an anonymous block that contains a PL/SQL function. Given an order number orderNo, the function will calculate the total number of the parts in the order. Then the anonym

Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

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

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

Projection and Existential Quantification - SQL Intuitively it might seem that projection in SQL is simply a matter of specifying the required columns in the SELECT clause, a