CENTRO DE FORMACIÓN
MODALIDAD
- Presencial
DURACIÓN
- 21 horas
LUGAR DE IMPARTICIÓN
- Aula Virtual
DOCENTES
- No disponible
El curso tiene como objetivo familiarizar a los participantes con el lenguaje de programación PL / SQL, sus posibilidades y limitaciones.
Create stored subroutines
- Compilation, object status, source codes
- Code encryption (wrap)
- Object dependency model
- Parameterization
Permissions and schemas in PL/SQL
- Owner and caller model
- Direct and role permissions
- Whitelist
- Assigning roles to procedures and inheriting permissions
Advanced Cursors
- Comparison of explicit cursors and cursor loops
- Pointers for weak and strong cursors
- Support for dynamic cursors
- FOR UPDATE cursors
Collections
- Associative tables (index by), nested tables and varrays
- Attributes, handling, initialization, memory allocation
- Bulk queries (BULK COLLECT) and bulk DML (FORALL)
- Bulk operations in dynamic SQL
- Exception handling in bulk operations
- Array and stream functions
Packages
- Package structure: specification and body
- Benefits of using packages
- Initialization section and global variables, memory management, package instance
Triggers
- DML triggers
- View triggers (INSTEAD OF)
- System Triggers
- Composite triggers
Application context and VPD
- Using built-in context
- Create your own private and global contexts
- Saving and reading context values
- Policies and Virtual Private Database
Appendix A - Examples of using embedded packages
- File handling (utl_file)
- Job scheduling (dbms_job and dbms_scheduler
Suggested pre-training
ORA_S1, ORA_P1
Suggested complementary training
ORA_SP3
Otros cursos bonificables de NobleProg:
¡Bonifica este curso!
Nosotros nos encargamos de gestionar la bonificación de estos cursos. Para información sobre la inscripción, CONTACTA CON EL CENTRO.