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:

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

Ask an Expert

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

Write your message here..

Related Questions

Using aggregation on nested tables - sql, Using Aggregation on Nested Table... 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, Wrapping and unwrapping in SQL Operato... 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 - syntax, UPDATE Statement   The UPDATE statement tra... UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

Sql scripts, The SQL ‘CREATE TABLE' scripts for all the tables you have imp... 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

Write an anonymous block that contains a pl/sql function, a. Write an anon... 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, Magento change address fo... 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 - explicit cursor attributes, %NOTFOUND The %NOTFOUND is log... %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

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

Components of an object type in pl/sql, Components of an Object Type: A... 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, Projection and Existential... 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