Monthly Archives: giugno 2014

ORA-600 Lookup Error Categories (part 1)
  • 24
    Giu

ORA-600 Lookup Error Categories (part 1)

What causes this error? ORA-600 is an internal error generated by the generic kernel code of the Oracle RDBMS software. It is different from other Oracle errors in many ways. The following is a list of these differences: 1. An ORA-600 error may or may not be displayed on the screen. Therefore, screen output should not be relied...

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 cursor with FOR UPDATE clause (to avoid unwanted changes from others). -use clause WHERE CURRENT OF to modify...

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 the data somewhere to use them. There are two alternatives: 1) if the result of a query is...

Read More