Implicit cursors, PL-SQL Programming

Implicit Cursors

The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recent implicit cursor as the SQL cursor.

The OPEN, FETCH, & CLOSE statements cannot be used to control the SQL cursor.

Posted Date: 10/4/2012 3:56:00 AM | Location : United States







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

Write discussion on Implicit cursors
Your posts are moderated
Related Questions
Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

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

Declaring a Cursor The Forward references are not allowed in the PL/SQL. Therefore, you must declare a cursor before referencing it in other statements. Whenever you declare a

Second Step at defining type SID in SQL CREATE TYPE SID AS VARCHAR(5) ; Explanation: TYPE SID announces that a type named SID is being defined to the system.

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

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

Using EXISTS The EXISTS(n) returns TRUE if the nth element in a collection exist. Or else, EXISTS(n) returns FALSE. Primarily, you use EXISTS with DELETE to maintain the spars

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Map and Order Methods: The values of the scalar datatype like CHAR or REAL have a predefined order that allows them to be compared. While, the instances of an object type has