MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

My author’s copies came

with 4 comments

My co-author got his author copies about a week before me. The technical editor got his complementary book too the same day. I was wondering where mine got routed but now I’ve got mine, a few days after it was available on Amazon.

I think the new book looks good. John and I were probably a real pain during the editing process because we kept asking for more control during the proof copy to get things fixed. I think we messed up the release schedule by a couple weeks.

John and I think that the mastery questions in each chapter work well. My students who’ve seen it think it’s great because of the review sections and its smaller size. I’m re-verifying the code now, and it should be on McGraw-Hill’s website next week.

Written by maclochlainn

February 1st, 2010 at 4:06 pm

Posted in Oracle,pl/sql

4 Responses to 'My author’s copies came'

Subscribe to comments with RSS or TrackBack to 'My author’s copies came'.

  1. Congradulations! I hope it proves a successful undertaking!

    As a side note, I would like to know how there are already two used copies available on (at a higher price than Amazon is selling them for new, I might add).


    2 Feb 10 at 2:16 am

  2. Hi Michael – are you familiar with the new pl/sql exam (11g Advanced PL/SQL 1Z0-146)? Can I ask:- would you say that reading your new book would be good prep for this exam, are many of the exam objectives covered across the content you’ve put into the book?

    many thanks in advance


    3 Feb 10 at 3:36 pm

  3. Craig,

    I guess the best way to answer that is on some elements, it (the Workbook) will help. On others, the Oracle Database 11g PL/SQL Programming (Reference) would be a better reference. A quick review of what I’d suspect you’ll find on this exam:

    Oracle 11g: Advanced PL/SQL
    We cover SQL*Plus in the Workbook and Reference, but you’ll need to know how to also use SQL Developer and Oracle JDeveloper.

    PL/SQL Programming Concepts: Review
    The Workbook tells you what you can’t do and what you can do with functions. It also describes SQL Expressions. It doesn’t, as the Oracle Education Training material does, explain that you can use a pass-by-value function in the SELECT list, conditional expressoin of the WHERE and HAVING clauses; the CONNECT BY, START WITH, ORDER BY, and GROUP BY; the VALUES clause of INSERT statements; and the SET clause of an UPDATE statement. Both books cover handling exceptions, but the Reference book provides the some of the dependency checking that you’ll need to know. Just make sure you understand timestamp and signature the database init.ora REMOTE_DEPENDENCIES_MODE parameter too. As to the Oracle supplied packages, neither book enumerates them all, but the workbook does list the packages with a brief description in Appendix D.
    Designing PL/SQL Code
    Both books covers cursor design and use, but cursor variables can mean a wide area of topics. I’d check this recent post provided for my students as a supplement. Make sure you understand the Simple loop with a local cursor structure variable example. The Workbook doesn’t cover shared cursors but the Oracle Education documentation does now. You need to understand how shared cursors work, which is covered in the Reference book. Creating and managing subtypes is covered in Chapter 3 of the Reference but not in the Workbook.
    Working with Collections
    The Workbook has a sweet and direct coverage of collections, it’s completely up to date and includes object tables (which I don’t think you’ll find on the test). However, the Collection API is on the test and is only covered in the Reference.
    Using Advanced Interface Methods
    You won’t find the External Procedures in the Workbook but there in Chapter 13 of the Reference. Deployment of Java is covered in Chapter 15 of the reference and includes an enumeration of rules. There are some effective examples in Chapter 12 of the Workbook (an architecture managing external tables and imports for ETL) but not a complete Chapter.
    Implementing Fine-Grained Access Control of VPD
    Not covered in either book. Before you dig into that subject, I’d suggest you check the discussion in the second part of the database authentication article that I wrote for OTN.
    Manipulating Large Objects
    LOBs are covered in Chapter 8 of the Reference book but the Workbook as a direct example of using temporary lobs in Chapter 12. Moreover, you might want to take a look at my presentation to the Oracle Utah User’s Group in 2008 on that topic.
    Administering SecureFile LOBs
    The Reference book only has a couple short pages showing you the elements necessary to set them up but clearly I should put it on my list for the blog.
    Performance Tuning
    Native and interpreted compilation modes are in the Reference book. Inlining is also in the Reference book. You can also check the Oracle Database 11g PL/SQL New Features presentation that I made to the Utah Oracle User’s Group.
    Improving Performance with Caching
    Both the Workbook and Reference show you how to use result caching. There’s aren’t any typos in the Workbook example but I think there are two in the Reference. I’m still waiting for the publisher to post the errata on the Reference. I provided it within 3 months of publication. I’m going to send an updated errata this week, and hope it gets posted. Probably an oversight on my part but I didn’t cover the DBMS_RESULT_CACHE package. That’s another opportunity for a blog post.
    Analyzing PL/SQL Code
    Both books cover this through appendixes. Some slight wording was reworked for the Workbook but they’re more or less the same between both books. We felt they needed to be in the Workbook for those who only bought one, and we didn’t see a need to re-write them. How to use the DBMS_METADATA package isn’t in either book.
    Profiling and Tracing PL/SQL Code
    The Profile is in both books but the tracing isn’t. It’s more a DBA subject but looking through this new test, I’ll make sure it’s in the 12g versions.
    Safeguarding your code against SQL injection attacks
    It is covered in Chapter 11 of the Reference book. Only the full description and a couple examples are in the Workbook.

    Just a followup, I’m fairly certain that you may see the following packages on the OCP test too: DBMS_DB_VERSION, DBMS_DDL, DBMS_SQL, DBMS_WARNING, STANDARD, UTL_FILE, and UTL_MAIL packages.

    I hope this helps answer your question.


    4 Feb 10 at 2:53 am

  4. Michael – this reply is much appreciated, thank you. This exam is comprehensive and you clearly need to know a lot about pl/sql. I’d like to sit the exam to get the ocp and I’ll be going through your points and references to help. many thanks.


    5 Feb 10 at 12:06 pm

Leave a Reply