What Are The Pl/sql Cursors?

1.	What Are The Pl/sql Cursors?
Answer» Oracle uses workspaces to EXECUTE the SQL COMMANDS. In other words, when Oracle processes a SQL command, it opens an area in the memory CALLED Private SQL Area. A cursor is an identifier for this area. It ALLOWS programmers to name this area and access it’s INFORMATION. Oracle uses workspaces to execute the SQL commands. In other words, when Oracle processes a SQL command, it opens an area in the memory called Private SQL Area. A cursor is an identifier for this area. It allows programmers to name this area and access it’s information.

Answer»

Oracle uses workspaces to EXECUTE the SQL COMMANDS. In other words, when Oracle processes a SQL command, it opens an area in the memory CALLED Private SQL Area. A cursor is an identifier for this area. It ALLOWS programmers to name this area and access it’s INFORMATION.

Oracle uses workspaces to execute the SQL commands. In other words, when Oracle processes a SQL command, it opens an area in the memory called Private SQL Area. A cursor is an identifier for this area. It allows programmers to name this area and access it’s information.

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?