What Are The Steps That Need To Be Performed To Use An Explicit Curso

1.	What Are The Steps That Need To Be Performed To Use An Explicit Cursor? Discuss Briefly.
Answer» The steps that need to be performed on explicit cursor are − DECLARE − assigns a NAME to the cursor and defines the structure of query within it. OPEN − EXECUTES the query, whereby the rows returned by the query are available for fetching. FETCH − assigns values from the current row (cursor POSITION) into SPECIFIED variables. CLOSE − releases the memory space. The steps that need to be performed on explicit cursor are − DECLARE − assigns a name to the cursor and defines the structure of query within it. OPEN − executes the query, whereby the rows returned by the query are available for fetching. FETCH − assigns values from the current row (cursor position) into specified variables. CLOSE − releases the memory space.

What Are The Steps That Need To Be Performed To Use An Explicit Cursor? Discuss Briefly.

Answer»

The steps that need to be performed on explicit cursor are −
DECLARE − assigns a NAME to the cursor and defines the structure of query within it.
OPEN − EXECUTES the query, whereby the rows returned by the query are available for fetching.
FETCH − assigns values from the current row (cursor POSITION) into SPECIFIED variables.
CLOSE − releases the memory space.

The steps that need to be performed on explicit cursor are −
DECLARE − assigns a name to the cursor and defines the structure of query within it.
OPEN − executes the query, whereby the rows returned by the query are available for fetching.
FETCH − assigns values from the current row (cursor position) into specified variables.
CLOSE − releases the memory space.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Three Basic Sections Of A Pl/sql Block?
State Some Features Or Programming Constructs Supported By Pl/sql.
Name Few Schema Objects That Can Be Created Using Pl/sql?
State Few Notable Characteristics Of Pl/sql.
What Does The Colon Sign (: ) Implies In The Following Statement? :deficit := Balance – Loan;
What Is The Purpose Of %type Data Type? Explain With Example.
What Is The Purpose Of %rowtype Data Type? Explain With Example.
What Is A Pl/sql Package?
What Are The Pl/sql Cursors?
What Is Returned By The Cursor Attribute Sql%rowcount?