Provided by: 123-CBT Computer Based Training Oracle PL SQL Procedures Functions Packages Click here for more information or to take this course

---

---

Training Provided by 123-CBT Computer Based Training

This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages.

Learn To:

• Identify the types and components of a subprogram.
• Create a subprogram.
• Create and use packages.

Content Emphasis

Skills-Based

Audience

Application Developers, Database Administrators, and Technical Support Professionals. Prior to taking this course, students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112).

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Subprograms: Procedures

• Match the various sections of a subprogram with their contents.
• Identify the components of developing environments.
• Identify the steps to create a subprogram.
• Identify the features of the different types of parameter modes.
• Perform the steps to create a client-side procedure by using Procedure Builder.
• Perform the steps to create a server-side procedure by using SQL*Plus.
• Identify the different methods for passing parameters.
• Perform the steps to create a bind variable by using SQL*Plus.
• Perform the steps to invoke a procedure from SQL*Plus.
• Perform the steps to invoke a procedure from another procedure by using SQL*Plus, a debug session in Procedure Builder.

Unit 2: Subprograms: Functions

• Perform the steps to create a client-side function by using Procedure Builder.
• Perform the steps to create a server-side function by using SQL*Plus.
• Perform the steps to invoke a function using Procedure Builder.
• Perform the steps to invoke a function using SQL*Plus.
• Identify the advantages of user-defined functions in SQL expressions.
• Identify the restrictions when calling user-defined functions from SQL expressions.
• Perform the steps to remove a subprogram.
• Identify the differences between a procedure and a function.

Unit 3: PL/SQL Packages

• Identify the uses of packages.
• Identify the features of package components.
• Identify the advantages of using packages.
• Create the statement of a package specification in SQL*Plus.
• Create the statement of a package body by using SQL*Plus.
• Match the Procedure Builder built-in packages with their features.
• Create the statement to invoke package constructs by using SQL*Plus.
• Identify how to reference a global variable within a package by using SQL*Plus.
• Identify the effect of the persistent state of a package cursor on dependent processor.
• Create the statement to remove a package.
• Perform the steps to start a debug session for a subprogram by using the PL/SQL Interpreter.
• Perform the steps to set a breakpoint by using the PL/SQL Interpreter in the Procedure Builder.
• Step through the code to determine the cause of an error by using the debug command icons.
• Perform the steps to modify local variable values in a debug session by using Procedure Builder.

Training Avaliability and Delivery

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD Contact 123-CBT Computer Based Training for more information

Training Presented in: English

About 123-CBT Computer Based Training - Training Provider

More Oracle SQL PL SQL Training from 123-CBT Computer Based Training

• Oracle PL SQL Database Programming
• Oracle SQL and SQL Plus Advanced SELECT Statements
• Oracle SQL and SQL Plus SQL Plus and Reporting
• Oracle SQL PL SQL Using Procedure Builder Curriculum
• Oracle SQL Specifics Creating and Managing Database Objects
• Oracle SQL Specifics Retrieving and Formatting Data
• Oracle SQL Tuning Diagnostics and Tuning Schema
• Oracle SQL Tuning Tuning SQL and the Optimizer