difference between implicit and explicit cursor, PL-SQL Programming

Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no need to declare oracle creates & process and closes by own automatically. the explicit cursor must be declared and closed by the external user.
Posted Date: 8/29/2012 3:12:34 AM | Location : United States







Related Discussions:- difference between implicit and explicit cursor, Assignment Help, Ask Question on difference between implicit and explicit cursor, Get Answer, Expert's Help, difference between implicit and explicit cursor Discussions

Write discussion on difference between implicit and explicit cursor
Your posts are moderated
Related Questions
I need to write one function and one procedure to query a Oracle 10.1 DB using PL SQL. I have the schema and exact queries...along with work Ive started and a template to put the a

Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

DELETE Statement The DELETE statement eliminates whole rows of data from the specified table or view. Syntax:

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Package Body: The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the pac

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the