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
Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

%TYPE: This attribute gives the datatype of a formerly declared collection, cursor variable, object, field, record, database column, or variable. Datatype: This is simply

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem

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

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th