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.

Osnovne informacije

Move Icon

  1. Maintain dependencies between PL/SQL subprograms.
  2. Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors).
  3. Create stored procedures and functions.
  4. Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code.
  5. Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output.
  6. Write dynamic SQL for more coding flexibility.
  7. Create overloaded package subprograms for more flexibility.
  8. Create triggers to solve business challenges.
  9. Create and debug stored procedures and functions.
  10. Describe the features and syntax of PL/SQL.
  11. Design PL/SQL anonymous blocks that execute efficiently.
  12. Design PL/SQL packages to group related constructs.
  13. Handle runtime errors.
  • Forms, PL/SQL i Application developerima
  • Administratorima baza podataka
  • Sistemskim analitičarima
  • Tehničkim konzultantima
Dobro poznavanje i iskustvo u radu s SQL-om. Programersko iskustvo je dobrodošlo.

Moduli koji će se izvoditi

  • ntroduction
  • 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

Brzi upit

Prijavite se

Lokacija 


Trajanje: 40 sati

Brzi upit