Course Outline
Complex data types, collections
- Subtypes
- Cursor variables and dynamic cursors
- Associative arrays, collections
- Actions mass, bulk, forall
- Exception handling bulk operations
Object orientation in an Oracle database
- Types (classes)
- methods of objects
- permanent Collections
- Functions Panel
- streaming Features
- Create your own aggregate functions
Calling functions in SQL, constraints, levels of purity, determinism
Organization of program units PL / SQL
- Permissions in PL / SQL
- Context name
Integration with other languages
- Using JAVA
- Linking procedures C language
- Native compilation of the C language
Ready solutions
- Create the application context
- Mechanism of Virtual Private Database (VPD)
- Support lobbying
- Profiling code
- Tracking code
Productivity PL / SQL code
- Bind variables in SQL statements and the statistical distribution of
- cursor Sharing
- Objective query optimization
- Feather short procedures at compile
- Caching functions and query results
Prevention before injecting code
Requirements
- The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
- Fluency in the basics of PL / SQL (preferably Oracle 11g completion of training - Programming with PL / SQL I - Workshops)
Testimonials (5)
The topic was interesting, and the trainer was very friendly and has adept knowledge of the subject.
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
During the training, all modules were discussed in great detail - for two days of training - and that was what I cared about the most.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Machine Translated
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Course - Oracle 11g - Programowanie w PL/SQL I - warsztaty
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
wiedza i przekłady