MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

PL/SQL Workbook Code

with 3 comments

I got a request Saturday for me to post code for the Oracle Database 11g PL/SQL Programming Workbook. You can download the book code here. It should also be on the McGraw-Hill web site tomorrow.

The irony for me is the timing of the request. I didn’t get it until late Saturday night when I had to make an early plane to Dallas, Texas on Sunday morning. It teaches me once again, that I should keep my book updates in one place and backup in a convenient carry-anywhere location.

I also found out that the Bulletin Board I’d set up wasn’t accessible. At least, accessible to anybody but bots. I uninstalled and re-installed it, and configured it. Now I’ll start maintaining it. You can find it at

Written by maclochlainn

February 10th, 2010 at 5:07 pm

Posted in Oracle,Oracle XE,pl/sql

3 Responses to 'PL/SQL Workbook Code'

Subscribe to comments with RSS or TrackBack to 'PL/SQL Workbook Code'.

  1. The original code file wasn’t correct, I’ve re-posted a complete file here under the existing link. It was sent two weeks ago to McGraw-Hill and should be on their site soon.


    13 Sep 11 at 12:28 pm

  2. Hi!

    I’m going through your Workbook and I stumbled upon a strange answer in the Chapter 7 quiz, question 13.


    Q: “A pipelined table function typically returns what type of variable?”

    A: B) A PL/SQL collection of a record data type.

    Explanation: That’s the purpose of a pipelined table function. It converts a PL/SQL collection to a SQL aggregate table or a normal SQL return result set.


    The chosen answer and the explanation don’t seem to have anything in common. Did you intend to choose A as the correct answer?

    A) A SQL collection of an object data type.


    14 Nov 12 at 6:43 am

  3. Yes, it’s an error. This old blog post should clarify variations about pipelined functions. I’ll put the errata on the bog over Thanksgiving.

    The answer and explanation should be:

    1. A SQL collection of an object data type.

    Explanation: The purpose of a pipelined table function converts a PL/SQL collection to a SQL aggregate table or a normal SQL return result set. That requires mapping any PL/SQL collection to a SQL collection that mirrors the list of components by data type position and size.


    14 Nov 12 at 1:35 pm

Leave a Reply