The Undiscovered Country: Useful Built-in Database Packages You’ve Never Heard About

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please see further down the page for a follow up to the Q+A. Watch video The video above is accompanied by the following downloadable scripts: 01_show_db_version.sql 02_show_dbms_assert.sql 03_show_parallel_execution.sql 04_show_utl_match.sql 05_show_dbms_alert.sql 06_show_utl_compress.sql 07_show_utl_inaddr.sql 08_show_owa_util.sql 09_show_apex_util.sql user_and_objects.sql Download all scripts (.zip)… Continue Reading →

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please see further down the page for a follow up to the Q+A.

The video above is accompanied by the following downloadable scripts:

I will make the test data available on our FTP server as soon as possible.

Summary

In this session we will take a look at some of the lesser known PL/SQL packages that come with the Oracle database. Packages like DBMS_ASSERT, DBMS_CRYPTO and DBMS_PARALLEL_EXECUTE. We will take a look at some of the utility packages that could come in handy such as UTL_NLA and UTL_MATCH, look briefly at some of the helper functions from UTL_INADDR and UTL_URL. At the end, I will take a look at some of the good packages from the Oracle community that will help you get your work done faster and smarter.

A live Q&A session with Morten Egan follows the presentation.

Follow up from the QA

Question: Could the compressed data be presented as a virtual column instead of a pipelined function?

I did a quick test, and yes it can. The code to do it, is here:

Question: Are any of the packages specific to a special edition of Oracle?

All the packages are available on both Standard Edition and Enterprise Edition.