Oracle 19c - PL/SQL
Details
| ID | 2757615 |
| Duration | 4.0 days |
| Methods | Lecture with examples and exercises. |
| Prerequisites | Oracle SQL, PL / SQL |
| Target group | DBAs, database developers |
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
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
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 filesCursor 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 SQLExceptions and Error Handling
Key topics of error handling - exception block - triggering and handling exceptions - exception types and complex exception handling in nested PL/SQL routinesCollections
PL/SQL collections and collection types - bulk load and bulk inserts - combination of collections and SQL - collection methods – collections and recordsNative 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 typesPL/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/SQLInstructor
Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.Publications
- Oracle PL/SQL (Comelio Medien)
978-3-939701-40-8 - Oracle SQL (Comelio Medien)
978-3-939701-41-5 - Oracle PL/SQL - Objektrelationale Techniken (Comelio Medien)
978-3-939701-42-2 - Oracle, PL/SQL und XML (Comelio Medien)
978-3-939701-49-1