MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Oracle PL/SQL Programming

with 56 comments

This links to my blog posts and pages dealing with PL/SQL programming. They include PL/SQL programming solution architectures, examples, techniques, and structures. The blog pages show below the top-level page in the right hand column, while blog posts only show in the list below.

If you have ideas of things that should be here that aren’t, leave a comment on the blog. In case you’re looking for my PL/SQL books, here are a couple links: Oracle Database 11g PL/SQL Programming or the Oracle Database 11g PL/SQL Programming Workbook.

Written by maclochlainn

November 12th, 2008 at 11:15 pm

Posted in Uncategorized

56 Responses to 'Oracle PL/SQL Programming'

Subscribe to comments with RSS or TrackBack to 'Oracle PL/SQL Programming'.

  1. Swapnil, Have you checked NUMTODSINTERVAL or NUMTOYMINTERVAL? These are variations of the string conversion TO_DSINTERVAL and TO_YMINTERVAL. The only difference is that the actual parameter being a number versus a string. I actually covered the TO_DSINTERVAL and TO_YMINTERVAL functions in the new Oracle Database 12c PL/SQL Programing book.


    9 Apr 14 at 10:31 am

  2. Thanks, will look for same…


    11 Apr 14 at 4:27 am

  3. Hi,your blog really helpful for me to gothrough the basic concepts..thanks!!


    4 Jul 14 at 4:18 am

  4. Hi Mac,

    Its been long time not taken any valuable suggestion from you 🙂

    I had a task to tune PL/SQL package .

    Can you please suggets the steps to achive same?

    One thing i know is about DBMS_PROFILER.

    Apart from this is there any way to achieve same?

    Db:Oracle 8i

    Apppreciate your efforts….



    21 Jul 14 at 7:04 am

  5. Hello, I am trying to work through your book ‘Oracle Database 12c PL/SQL Programming’ and I have downloaded the

    The files for ‘Introduction’ appear to be somewhat out of date for 12c and the scripts have typos and no general instructions on use.

    A little cleanup, etc. could help novices such as me.



    21 May 15 at 1:53 pm

  6. Charles, I don’t know which version you have but here’s the 12cPLSQLCode file that I use in class. If you find any errors, drop me a note and I’ll fix it.

    After you unzip the file, navigate to the Introduction folder and run the create_oracle_store.sql script. That script calls all the other scripts.

    This is what you see in the Introduction folder:




    21 May 15 at 9:04 pm

Leave a Reply