• Oracle Database: Develop PL/SQL Program Units

Oracle Database: Develop PL/SQL Program Units

This Oracle Database: Develop PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Program Units in this powerful programming language.


On successful Completion of this course you will be able to:


  • Describe stored procedures and functions
  • Create, use and debug stored procedures and functions
  • Design and use PL/SQL packages to group and contain related constructs
  • Create overloaded package subprograms for greater flexibility
  • Use Oracle supplied PL/SQL packages to generate console and file output
  • Write dynamic SQL for more coding flexibility
  • Create Triggers
  • Manage dependencies between PL/SQL subprograms
Course Requirements
Prerequisites Required Prerequisites Basic knowledge of database concepts, including relational database management systems (RDBMS). Familiarity with data processing concepts and techniques. Oracle Database: Introduction to SQL (combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II listed) Oracle Database: SQL Fundamentals I Suggested Prerequisites Previous programming experience

Write a review

Please login or register to review

Oracle Database: Develop PL/SQL Program Units

  • Brand: Weblearning Publishing
  • Product Code: Oracle Database: Develop PL/SQL Program Units
  • Reward Points: 100
  • Availability: In Stock
  • £92.99
  • £73.99

  • Price in reward points: 1200

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai SQL Workshop

Oracle Database 23ai SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Big Data Unlimited

Big Data Unlimited

Big Data Unlimited Cloud Learning SubscriptionThe Big Data  Unlimited Cloud Learning Subsc..

£365.00 £399.00

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..

£249.00 £279.00

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..

£124.00 £149.99

Tags: Database Management, Oracle Database, SQL, PL/SQL, Programming, DBA