Oracle Database - (Query) Work Area

Card Puncher Data Processing

About

The work area is an memory area that is used to perform data operation such as:

It's in the PGA





Discover More
Card Puncher Data Processing
PL/SQL - Cursor

A cursor in the context of Oracle. A cursor is a SQL datatype. A cursor is a pointer to a private SQL area that stores information processing a specific: SELECT or DML statement. The cursor data...
Oracle Database Sql Processing
Sql Engine - Relational Operator (Data operations|Execution Plan Steps)

Relational operator They are the step of a plan (execution parse tree). List read () filter, sort, join aggregation .... Type of operation using the work area: SORT, HASH JOIN,...



Share this page:
Follow us:
Task Runner