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 learn how to create, compile, and execute Procedures, Functions, and Packages which are named program units that are pre-compiled and stored in the database. These are powerful programming constructs which help with increasing the


  • +

    Course Syllabus

    ● Overview
        ◦ Overview
        ◦ Benefits of Named Program Units
        ◦ Prerequisites
        ◦ Audience
        ◦ Tools
    ● Procedures
        ◦ What is a Procedure?
        ◦ Defining Procedures
        ◦ Compiling Procedures & Native Compilation
        ◦ PLSQL_OPTIMIZE_LEVEL & Compile for Debug
        ◦ Errors and Warnings
        ◦ Executing Dropping & Terminating Procedures
        ◦ Summary
    ● Functions
        ◦ What is a Function?
        ◦ Oracle Provided Functions
        ◦ Defining Functions
        ◦ Compiling & Executing Functions
        ◦ Dropping & Terminating Functions
        ◦ Demo
        ◦ Summary
    ● Parameters in Procedures & Functions
        ◦ Introduction
        ◦ Formal vs. Actual Parameters
        ◦ Parameter Modes
        ◦ Passing by Reference & Value
        ◦ NOCOPY hint
        ◦ Positional, Named & Mixed Notation
        ◦ Default Values & Constraints on Formal Parameters
        ◦ Summary
    ● Local Subprograms
        ◦ Introduction
        ◦ Defining Local Subprograms
        ◦ Exceptions, Scope & Visibility of Variables
        ◦ Summary
    ● Package Specification
        ◦ Introduction
        ◦ Why Use Package Specifications?
        ◦ Package Structure & Contents
        ◦ Defining Package Specification
        ◦ Compiling Package Specification
        ◦ Executing & Dropping Package Specification
        ◦ Global Variables & Session State
        ◦ Demo
        ◦ Summary
    ● Package Body
        ◦ Introduction
        ◦ Defining Package Body
        ◦ Package Initialization
        ◦ Compiling & Executing Package Body
        ◦ Order of Subprograms & Forward Declaration
        ◦ Stateful & Stateless Packages
        ◦ Overloading Subprograms
        ◦ Overloading Considerations
        ◦ Summary
    ● Calling Functions from SQL
        ◦ Where Can They Be Called?
        ◦ Restrictions
        ◦ Deterministic
        ◦ Parallel Enable
        ◦ Pragma Restrict References
        ◦ Summary
    ● Roles & Privileges With Subprograms
        ◦ Subprogram Resolution
        ◦ AUTHID DEFINER
        ◦ AUTHID CURRENT_USER
        ◦ Execution Flow Between Invoker & Executor
        ◦ Direct Grants vs. Roles
        ◦ Summary
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

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
REDHERRING
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