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
V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Example of Null operator - NiNo Rule If we wanted to make HIGHER_OF adhere to "NULL in, NULL out"-let's call it the NiNo rule-we would have to write something like what is sho

Multiset types - SQL An SQL multiset is what in mathematics is also known as a bag-something like a set except that the same element can appear more than once. The body of an

NULL Statement The NULL statement clearly specifies in action; it does nothing other than to pass control to the next statement. It can, though, improve the readability. In a

SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE

JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op

Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause:

Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference