Tag Archive: cursor

EXPLICIT CURSORS – modify tables
  • 9
    Lug

EXPLICIT CURSORS – modify tables

In the previous article (cursors overview) we have seen simple examples with SQL statements. You can also use cursor to modify database tables. If we want to use explicit cursor to update or delete data, we need to: -declare the...

Read More
EXPLICIT CURSORS – modify table
  • 17
    Giu

EXPLICIT CURSORS – modify table

In the previous article (cursors overview) we have seen simple examples with SQL statements. You can also use cursor to modify database tables. If we want to use explicit cursor to update or delete data, we need to: -declare the...

Read More
Cursor Overview
  • 10
    Giu

Cursor Overview

Suppose you have a database; you can have access to your data through a query as: SELECT […your cols…] FROM […your tables…] WHERE […your conditions…]; However, from a PL/SQL program, is not sufficient to run query, you need to store...

Read More