Oracle Database 19c: PL/SQL Workshop

Descripción

This is a complete course on PL/SQL including an introduction to Programming and Managing the PL/SQL code.

Objetivos

• Get an overview of PL/SQL
• Learn how to declare variables
• Write executable statements
• Learn how to use SQL statements in PL/SQL Programming

Contenidos del curso

1. Introduction
2. Introduction to PL/SQL
3. Declaring PL/SQL Variables
4. Writing Executable Statements
5. Using SQL Statements Within a PL/SQL Block
6. Writing Control Structures
7. Working with Composite Data Types
8. Using Explicit Cursors
9. Handling Exceptions
10. Introducing Stored Procedures and Functions
11. Creating Procedures
12. Creating Functions
13. Debugging Subprograms
14. Creating Packages
15. Working with Packages
16. Using Oracle-Supplied Packages in Application Development
17. Using Dynamic SQL
18. Creating Triggers
19. Creating Compound, DDL, and Event Database Triggers
20. Design Considerations for the PL/SQL Code
21. Tuning the PL/SQL Compiler
22. Managing Dependencies

 

A    Using SQL Developer

B     Using SQL*Plus

C     Commonly Used SQL Commands

D    REF Cursors

E     Managing PL/SQL Code

F     Implementing Triggers

G    Using the DBMS_SCHEDULER and HTP Packages