What are PL/SQL cursors?

devquora
devquora

Posted On: Feb 22, 2018

 

PL/SQL controls the context area through cursors. PL/SQL requires cursors to retrieve and process more than one row. A cursor is a pointer to the area of the memory containing SQL statements and information for processing the statements. PL/SQL is a mechanism under which multiple rows are selected from the database. Then, each row selected is individually processed inside PL/SQL programs.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    PL/SQL Interview Questions

    What is PL/SQL?

    PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..

    PL/SQL Interview Questions

    Differentiate between PL/SQL and SQL?

    PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..

    PL/SQL Interview Questions

    State few characteristics of PL/SQL?

    Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..