IT / Programming / Oracle / Oracle 19c / PL/SQL 1
| ID | 2757615 |
|---|---|
| Classroom | 4 days 9:00-16:30 |
| Webinar | 5 days 9:00-12:30 |
| Method | Lecture with examples and exercises. |
| Prequisite | Oracle SQL, PL / SQL |
| Audience | DBAs, database developers |
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.
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
Declaration of Cursors in PL/SQL - cursor handling - data processing with cursors - attributes and parameters - cursor variables - cursor expressions in SQL
Key topics of error handling - exception block - triggering and handling exceptions - exception types and complex exception handling in nested PL/SQL routines
PL/SQL collections and collection types - bulk load and bulk inserts - combination of collections and SQL - collection methods – collections and records
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 procedures - functions - parameters - local modules - overloading - use PL/SQL packages - triggers (DML, Instead-of-trigger, system triggers)
Object-relational data structures and their usage in PL/SQL - XML integration with Oracle and XML processing in PL/SQL
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.
He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
