Kategorier: Alle - sessions - procedures

af Andrea Garduno 10 år siden

338

plsql_fnc

The text revolves around the use and management of PL/SQL within an Oracle database environment. It touches on various elements such as PL/SQL procedures and functions, user-defined and system triggers, and Oracle packages.

plsql_fnc

plsql_fnc

oracle packages calls

bind variables

PL/SQL concurrent with enque / deque

PL/SQL DML & Commits

EBS

PL/SQL with synchronized SQL

long running PL/SQL procedures

several sessions

system triggers

user defined triggers

PL/SQL & Recursive SQL

recursive SQL's

PLSQL procedures

common PL/SQL Calls

simple workload

setup / restore-copy emp. table into a new one workload-create a function to update salary workload -update the salary of some employees verify - consults updated rows