view counter


Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

Ah, Those Edge Cases! (11632)

The 27 March quiz tested your knowledge of collections, and the kinds of assumptions you might make when writing a program that accepts a collection as a parameter.

Good Deeds - It's All Relative

A "news analysis" piece in the Sunday New York Times, titled "Text to Driver: That’s My Space," that explores a growing phenomenon of "parking rage." That's when you sit in your car in your parking spot and do some texting or emailing or twittering or facebooking or....anything that involves having your head bent over a small smartphone device and moving your thumbs, rather than driving away and letting someone else use the parking spot.


While working through prepared statements in MySQL, there was an interesting regular expression question raised. A student wanted to know how to address the following error message:

ORA-03113 and Bulk Collect

It can be quite frustrating when you are working on a database package and your session is terminated time and time again and leaves you clueless as too why this is happening. First of all, this is reproducible on an Oracle 10g Enterprise Edition - haven't tried other versions (yet).

SQL> @../utils/rel

Oracle Database 10g Enterprise Edition Release - 64bi
PL/SQL Release - Production
CORE Production

Two Years of the PL/SQL Challenge, and Looking Ahead

The second anniversary of the PL/SQL Challenge's launch date (8 April) approaches. Two years of daily quizzes, and so much more. Excellent time to reflect on how things have gone and how they can be improved in the future.

Ohio and New York High Performance PL/SQL Trainings

I will be doing one day trainings on high performance PL/SQL and Oracle Database 11g new features in Columbus and Manhattan (NY) in April:

April 16 - Columbus more info
April 18 - Manhattan more info

These are one day, whirlwind explorations of the many ways you can get those PL/SQL programs running faster, including:

Enjoy reading…enjoy PacktLib

Hi, Nice to see a new development for Indian techies from Packt publishers. The publishers library PacktLib is now free for tech readers in India. Interested readers can create their account and use the library for free from 8 to 8. Find more information at……Enjoy Bye, Saurabh Filed under: Oracle

Oracle CSV Imports

The first step in creating an effective import plan for comma-separated value (CSV) files is recognizing your options in a database. There are several options in an Oracle database. You can read the file with Java, C/C++, C#, PL/SQL (through the UTL_FILE package), PHP, Perl, or any other C-callable programming language; or you can use SQL*Loader as a standalone utility or through externally managed tables (known as external tables). The most convenient and non-programming solution is using external tables.

Recursive Foot-in-Mouth Syndrome

The Republican primary contest has offered many examples of the well-known Foot-in-Mouth Syndrome, whereby candidates say things that cause them, at a minimum, some embarrassment and, even worse for them, lost votes.

Today while reading the Chicago Tribune, I discovered a rare variation of the syndrome, Recursive Foot-in-Mouth Syndrome (RFIM), in which a candidate, while explaining why his foot was planted firmly in his mouth, plants a foot within that foot.

Methodical Performance Tuning Part 2 by Arup Nanda: AIOUG webcast

Arup Nanda delivers yet again a useful webcast on Oracle performance tuning practices. This time he shows the utilization of V$ views to analyse the session level waits and statistics. Download links are as below Besides, the reviewing activities on “Book in Making” are going smooth.

view counter