Oracle PLSQL
In this course you will learn the main structures of PLSQL: the blocks, the loops, exceptions, variables. And you will see that PLSQL (or also written as PL/SQL) is used in many, many Oracle products. You can use it to split very complex queries to more manageable pieces, to improve performance and for advanced security.
This course is one of the more fundamental courses (together with SQL and Stored Procedures) for many Oracle courses.
Course Formats
This course is available as:
- Instructor led training
- e-Learning
- Book
- Any combination of the 3 options
Audience
- End User
- Implementer
- Manager
Topics
- Why use PL/SQL
- Use of Data-Types
- Anchored Data Type
- PL/SQL Blocks
- Declaring Variables with the %TYPE Attribute
- Loops: Simple Loop
- Printing Output
- Functions and Procedures
- Errors in a Procedure
- Stored Procedures
- Block Definition
- Variables and Types
- Control flow in PL/SQL
- And many more…