Oracle PL/SQL

Oracle PL/SQL

Released October 2011
Publisher(s): Infinite Skills
ISBN: 9781926873718

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

In this training course by Lewis Cunningham on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.
Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there!
By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.

Table of contents

  1. Introduction
    1. What Is PL/SQL
    2. Course Expectations
  2. An Overview Of PL/SQL
    1. The Difference Between SQL And PL/SQL
    2. Where To Access Oracle - Part 1
    3. Where To Access Oracle - Part 2
    4. Block Structure
    5. Functions Procedures Packages
    6. Data Types
    7. Complex Objects
    8. Variables Constants Parameters - Part 1
    9. Variables Constants Parameters - Part 2
    10. Flow Control
    11. Errors Exceptions
    12. Commenting Code
  3. Data Types In Detail
    1. Strings
    2. Numbers
    3. Date And Time
    4. Booleans Lobs
  4. Complex Data Structures
    1. Records
    2. Associative Array
    3. Nested Tables
    4. Varrays
    5. Arrays Of Records
  5. Programming PL/SQL
    1. SQLplus
    2. SQL Developer - Part 1
    3. SQL Developer - Part 2
  6. A First Program
    1. Hello World
    2. Create Assign Use Variables
    3. Create Procedure
    4. Autonomous Transactions
  7. Flow Control
    1. If Statements
    2. Case Statements
    3. Loops - Part 1
    4. Loops - Part 2
  8. Functions
    1. Functions - Part 1
    2. Functions - Part 2
    3. Built in Functions
  9. Exception Handling
    1. What Are Exceptions - Part 1
    2. Predefined Exceptions
    3. Raising Exceptions
    4. Suggestions For Exception Handling
    5. User Defined Exceptions
  10. SQL In PL/SQL
    1. Inserting In PL/SQL
    2. Updates And Deletes In PL/SQL
    3. Selecting Data In PL/SQL
    4. Cursors
    5. Cursor For Loops
    6. Bulk Operations
  11. Packages
    1. Package Specifications
    2. Package Bodies
    3. Public And Private Globals - Part 1
    4. Public And Private Globals - Part 2
    5. Package Initialization
    6. Forward Declarations
    7. Package Cursors
    8. Utl File
    9. Overloading
  12. Triggers
    1. DML Triggers
    2. Compound Triggers
    3. Instead Of Triggers
    4. Database Triggers
  13. PL/SQL Objects
    1. Object Types
    2. Constructors
    3. Members
    4. Equality
    5. Inheritance
  14. Dynamic SQL
    1. Dynamic SQL
    2. DBMS SQL - Part 1
    3. DBMS SQL - Part 2
    4. DBMS SQL - Part 3
    5. DBMS SQL - Part 4
    6. NDS - Part 1
    7. NDS - Part 2
  15. About The Author
    1. About Me

Product information

  • Title: Oracle PL/SQL
  • Author(s):
  • Release date: October 2011
  • Publisher(s): Infinite Skills
  • ISBN: 9781926873718