Program with PL/SQL predstavlja uvod u programiranje Oracle baze podataka korištenjem programskog jezika PL/SQL na način da se tijekom treninga usvajaju znanja i vještine o sintaksi, strukturi i funkciji jezika.
PL/SQL se može smatrati jednim od osnovnih skupova vještina potrebnih svakom Oracle profesionalcu, gotovo jednako važnim kao i sam SQL jezik. Fokus ovog treninga bit će na korištenju pohranjenih programskih jedinica u bazi podataka kao što su procedure, funkcije, paketi i trigeri. Također su objašnjene i demonstrirane nove funkcije uvedene s najnovijim verzijama Oracle baze podataka.
Što ćete naučiti
- Maintain dependencies between PL/SQL subprograms.
- Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors).
- Create stored procedures and functions.
- Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code.
- Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output.
- Write dynamic SQL for more coding flexibility.
- Create overloaded package subprograms for more flexibility.
- Create triggers to solve business challenges.
- Create and debug stored procedures and functions.
- Describe the features and syntax of PL/SQL.
- Design PL/SQL anonymous blocks that execute efficiently.
- Design PL/SQL packages to group related constructs.
- Handle runtime errors.
Kome je namijenjeno
- Forms, PL/SQL i Application developerima
- Administratorima baza podataka
- Sistemskim analitičarima
- Tehničkim konzultantima
Preduvjeti
Dobro poznavanje i iskustvo u radu s SQL-om. Programersko iskustvo je dobrodošlo.
Nastavni plan
Pregledaj
- Dan 1
- Introduction
- Introduction to PL/SQL
- Declaring PL/SQL Variables
- Writing Anonymous PL/SQL Blocks
- Using SQL Statements in PL/SQL Programs
- Writing Control Structures
- Working with Composite Data Types
- Using Explicit Cursors
- Handling Exceptions
- Introducing Stored Procedures and Functions
- Introduction
- Creating Procedures
- Creating Functions and Debugging Subprograms
- Creating Packages
- Working With Packages
- Using Oracle-Supplied Packagesin Application Development
- Using Dynamic SQL
- Design Considerations for PL/SQL Code
- Creating Triggers
- Creating Compound, DDL, and Event Database Triggers
- Using the PL/SQL Compiler
- Managing Dependencies