CTS

Individual training solutions

+48 12 655 17 36  

Oracle

O_PL/SQL Training Oracle Programming in PL/SQL

Training name: O_PL/SQL Training Oracle Programming in PL/SQL

Duration (in days): 3 days

Description

The course contains knowledge about PL/SQl language. Its use in the oracle environment. Students learn how to build functions, stores procedures, triggers and more advanced pieces of programs.Acquainting participants in training with PL/SQL programming languages, as programming languages databases is aimed at this course Oracle and with programming languages in the integrated programming environment Oracle Developer. A principle of operation of this tongue is being discussed on the database server, creating both basic and folded programming structures.

Objectives

Students learn how to build functions, stores procedures, triggers and more advanced pieces of programs.Acquainting participants in training with PL/SQL programming languages, as programming languages databases is aimed at this course Oracle and with programming languages in the integrated programming environment Oracle Developer.

Audience

The route is intended for everyone which are working at creating the application based on the relational base Oracle with using PL/SQL programming languages.

PreRequisites

Everyone which are working at creating the application based on the relational base Oracle with using PL/SQL programming languages.

Topics

1.PL/SQL language objects:
    anonymouse blocks
    objects stored in database
    objects related to reports and formatting
2.PL/SQL in SQL*Plus
    executing the code
    bind variables
    capture the results
3.Data types
    scalar
    complex
    anchor
    LOB
4.Working with database
5.Anonymous PL/SQL blocks
    executing
    parameters
6.Conditional instructions
7.Iterative instructions
8.Procedures
9.Functions
10.Exception handling
    buit-in exceptions
    user errors
    error codes and names
    functions for exception handling
11.Cursors
    implicite cursors
    creating and managing explicite cursors
    cursor's attributes
    parametrizing cursor
12.Dynamic SQL
    Execute immediate
13.Records
14.Packages
    package specification
    package body
    overloading procedures and functions
15.Database troggers
    types of triggers
    DML triggers
    row and statement triggers
    use of presudorecords
    trigger limits
    managing triggers
16.Code wrapping
17.Autonomous transactions

In case customers from Poland prices can be negotiated

VAT not incl. It concerns only customers from Poland

%}