About Training
DESCRIPTION
Duration: 20 h
Target: Audience Professionals who want to develop programs of units (PL / SQL blocks) for both database administration as to supply computer systems requirements.
Requirements: Database Concepts, Basic knowledge of SQL.
Course Objectives
• Know the PL / SQL block
• Understand the classical structures of programming in PL / SQL
◦ Decision sequential and repeat
• Create stored procedures
◦ functions, procedures, packages and triggers databases
PL/SQL Language | Structures |
PL/SQL blocks Setting Variables Conditional |
IF, THEN, ELSE Repeating Structures LOOP, WHILE, FOR GOTO statement Working with Labels |
Manipulating PL/SQL Data | |
Working with Sliders Implicit cursor Explicit cursor Cursor OPEN-FOR |
Working with Functions | Working with Procedures |
Creating, changing, and deleting | Criando, Alterando e Excluindo |
Working with Packages | Working with Triggers |
Creating, changing, and deleting Package Global Variables Functions and Procedues Public and Private |
Triggers Tables Events: Inclusion, alteration, exclusion Database Triggers Events: Startup, Shutdown |
Handling Exceptions | |
Exceptions Concepts handling Exceptions User-defined exceptions |

Hire