Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Central London
City
England
Berkshire
Manchester (Greater)
Scotland
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This course is highly interactive and consists of theory coupled with plenty of hands on practical sessions. It provides an in-depth look at PL/SQL in the SQL*Plus environment in order to create and use user defined packages, as well as be able to use Oracle supplied packages. The course also covers creation of Database Triggers and use of the Native Dynamic SQL (NDS). Audience This course is for programmers and support staff who wish to gain a comprehensive understanding of how the Oracle Procedural Language / Structured Query Language (PL/SQL) can be used in order to utilise Packages, Triggers and Native Dynamic SQL (NDS). Skills Gained After completing the course, delegates will be able to: - Write user defined Packages and Triggers.
- Produce PL/SQL code that uses Oracle supplied Packages.
- Create re-usable code with NDS.
Prerequisites Delegates should be computer literate with a good knowledge of Oracle SQL and SQL*Plus and the standard editor available on their target hardware platform. Understanding of Oracle PL/SQL programming concepts and techniques is also required. Previous attendance of our course Oracle PL/SQL Programming Level 1 is highly recommended. Course Outline - Write user defined Packages and Triggers.
- Produce PL/SQL code that uses Oracle supplied Packages.
- Create re-usable code with NDS.
- Packages
- Built-In Packages
- Native Dynamic SQL (NDS)
- DDL and Database Level Triggers
- Collections
- External Procedures and Java Integration
How to make a booking for the ORPL2 course
|
