MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Oracle PL/SQL Fundamentals - Part 2

Course Summary

In this course, we will take an in-depth look at Procedures, Functions, and Packages. These named program units are powerful programming constructs which can greatly enhance and optimize your code.

  • +

    Course Syllabus

    - 8m 17s

    —Overview 2m 38s
    —Benefits of Named Program Units 2m 16s
    —Prerequisites 0m 52s
    —Audience 1m 5s
    —Tools 1m 25s
    - 39m 54s

    —What is a Procedure? 3m 0s
    —Defining Procedures 4m 39s
    —Compiling Procedures & Native Compilation 3m 29s
    —PLSQL_OPTIMIZE_LEVEL & Compile for Debug 4m 36s
    —Errors and Warnings 6m 45s
    —Demo: Creating & Compiling Procedures, Errors and Warnings 9m 42s
    —Executing Dropping & Terminating Procedures 2m 30s
    —Demo: Executing Dropping & Terminating Procedures 3m 48s
    —Summary 1m 21s
    - 33m 11s
    Parameters in Procedures & Functions
    - 49m 34s
    Local Subprograms
    - 18m 26s
    Package Specification
    - 28m 42s
    Package Body
    - 48m 33s
    Calling Functions from SQL
    - 31m 14s
    Roles & Privileges With Subprograms
    - 52m 28s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top