Oracle 19c - PL/SQL
Course Overview
| ID | 2102002 |
| Duration | 4.0 days |
| Methods | Lecture with examples and exercises. |
| Prerequisites | Oracle SQL, PL / SQL |
| Target group | DBAs, database developers |
| Vorgängerkurs | 2102001 |
Overview
PL/SQL is an SQL-based procedual programming language that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database. PL/SQL is tightly integrated with SQL. With PL/SQL, you can use all SQL data manipulation, cursor control, and transaction control statements, and all SQL functions, operators, and pseudocolumns. Oracle provides product-specific packages that define APIs you can invoke from PL/SQL to perform many useful tasks. You can create standalone subprograms (procedures and functions) at schema level. They are compiled and stored in the database, where they can be used by any number of applications connected to the database. This training introduces you to the basic syntax of PL/SQL and shows you then how to develop scripts, procedures, functions or triggers.
Dates
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Learn with customized examples and content—precisely tailored to your requirements.
Your benefits at a glance
- Flexible preferred date
- Customized content
- Intensive exchange
- High practical relevance
Description
Learn Oracle PL/SQL programming to create procedures, functions, and triggers directly in the Oracle database. Learn how to structure data in your PL/SQL applications and then deploy it in packages.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Content
PL/SQL Syntax
Basics of PL/SQL: programming concept of Oracle applications, PL/SQL blocks, variables, data types - control structures: conditional statements, loops - transaction management - data record types and records - working with files
Cursor for SQL Queries in PL/SQL
Declaration of Cursors in PL/SQL - cursor handling - data processing with cursors - attributes and parameters - cursor variables - cursor expressions in SQL
Exceptions and Error Handling
Key topics of error handling - exception block - triggering and handling exceptions - exception types and complex exception handling in nested PL/SQL routines
Collections
PL/SQL collections and collection types - bulk load and bulk inserts - combination of collections and SQL - collection methods – collections and records
Native Dynamic SQL
Dynamic SQL and its execution at run-time in PL/SQL - parameters - bulk inserts and bulk binding / mass data processing - using native dynamic SQL with cursors, collections and record types
PL/SQL Modules in Oracle
PL/SQL procedures - functions - parameters - local modules - overloading - use PL/SQL packages - triggers (DML, Instead-of-trigger, system triggers)
Overview of PL/SQL Extensions
Object-relational data structures and their usage in PL/SQL - XML integration with Oracle and XML processing in PL/SQL
Instructor
Our Oracle trainer, Marco Skulschus, studied economics with a focus on business informatics in Wuppertal and Paris and has been working as an Oracle trainer and Oracle DB developer for data warehousing and reporting solutions for over 10 years. He has published several books on Oracle SQL and Oracle PL/SQL.
Publications
- Oracle SQL (Comelio Medien )
978-3-939701-41-5 - Oracle PL/SQL (Comelio Medien )
978-3-939701-40-8 - Oracle PL/SQL - Objektrelationale Techniken (Comelio Medien )
978-3-939701-42-2 - Oracle, PL/SQL und XML (Comelio Medien )
978-3-939701-49-1 - Oracle 10g: Programmierung mit PL/SQL, Java, PHP und C++ (Galileo Computing )
978-3898423144