Oracle PL/SQL
COURSE FEATURES
PL/SQL, the Oracle procedural extension of SQL, is a portable, high-performance transaction-processing language. This overview explains its advantages and briefly describes its main features and its architecture.
This course is taught in Romanian and course materials can be in either English, or Romanian. The course can be customized, on request.
DAY
1
TOPICS
3
TOPICS
3
The general structure of a PL/SQL block
Variabile
Structures "control flow"
DAY
2
TOPICS
5
TOPICS
5
Exceptions
Collections
Associative array
Nested table
Varray
DAY
3
TOPICS
8
TOPICS
8
Cursors
Explicit
Implicit
Select into
Parametrizate
Bulk collect, Forall
Relation with DML (where current of)
REF cursor
DAY
4
TOPICS
2
TOPICS
2
SQL dinamic
Transactions
DAY
5
TOPICS
1
TOPICS
1
Stored procedures, functions, packages
Contact Us
Feel free to leave us your thoughts so we can discover the solution together!
academy@esolutions.ro
Get in touch
0753.029.187
Our address
20 Constantin Budisteanu Street , 1 st. District, Bucharest
academy@esolutions.ro
Get in touch
0753.029.187
Our address
20 Constantin Budisteanu Street , 1 st. District, Bucharest