What Do You Understand By Explicit Cursors?

1.	What Do You Understand By Explicit Cursors?
Answer» Explicit cursors are defined explicitly USING the CURSOR statement, with a general SYNTAX − CURSOR cursor_name [(parameters)] IS query_expression; It allows PROCESSING queries that return multiple rows. Explicit cursors are defined explicitly using the CURSOR statement, with a general syntax − CURSOR cursor_name [(parameters)] IS query_expression; It allows processing queries that return multiple rows.

Answer»

Explicit cursors are defined explicitly USING the CURSOR statement, with a general SYNTAX −
CURSOR cursor_name [(parameters)] IS query_expression;
It allows PROCESSING queries that return multiple rows.

Explicit cursors are defined explicitly using the CURSOR statement, with a general syntax −
CURSOR cursor_name [(parameters)] IS query_expression;
It allows processing queries that return multiple rows.

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?

What Do You Understand By Explicit Cursors?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment