view counter

PL/SQL Feed

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

Gingrich the Historian: Bring Back Child Labor!

"It is tragic what we do in the poorest neighborhoods, entrapping children in, first of all, child laws, which are truly stupid," said the former House speaker Friday at the Kennedy School of Government at Harvard. "Most of these schools ought to get rid of the unionized janitors, have one master janitor and pay local students to take care of the school.

Explanation for Slow Performance of VARCHAR2 Overloading?

Valentin Nikotin, a PL/SQL Challenge player, recently brought to my attention some unexpectedly slow performance when executing from within a query an overloaded function that accepts a VARCHAR2 argument, compared to a NUMBER argument. I have been able to reproduce this (see below). I thought I'd see if any readers of this blog had an idea as to what might be the cause.

We both ran this code on an 11.2 instance.

My First Song for Loey

Loey is a busy, active little baby. Eating very well, but in between feedings she is a wiggly little package. A few nights ago, I was holding her but she couldn't find a comfortable position.

NVIDIA Strikes MacBook Pro

The distorted video problems introduced by NVIDIA on MacBook Pro is old news because it affected early 2008 machines. Alas, those intermittent little gray lines at the bottom of my MacBook Pro early 2008 model now transcend my screen 4 out of 5 boot cycles, as shown below:

MySQL and Java Tutorial

This demonstrates how to create an Java infrastructure for reading and writing large text files to a MySQL database. The example provides:

Excel-Oracle ODBC Driver

Somebody was trying to query Oracle via Microsoft Excel 2007, and didn’t have an Oracle ODBC Data Source that enable them to choose Oracle. I’d referred them to this post on adding MySQL’s ODBC driver to Windows 7 but that didn’t help enough. Posting this screen shot may not have helped either.

"God Told Me to Do It"

Such a statement made by, say, a murderer would be a strong indication of mental illness.

So what does it say about a Republican candidate for President of the United States?

Like Herman Cain, who said in a speech today to a national meeting of young Republicans:

How Reliable are PL/Scope Results? (9403)

The 9 November quiz on PL/Scope asked players to draw conclusions about a package body from the data in the user_identifiers view.

One of our most dedicated players, Iudith Mentzel, spent some time testing out the results one gets from PL/Scope (and queries against user_identifiers) for various uses of labels and GOTOs. I publish her comments below for your consideration.

From Iudith Mentzel

Oracle SQL Tuning Example

Somebody wanted a post on SQL statement tuning, so here it is. SQL statement tuning requires that you understand table definitions, constraints, and indexes plus how they interact through joins before you can begin tuning. Oracle presents some of the most advanced tools for tuning SQL statements.

Can Choice Be Correct If Error Raised? (9401)

The 7 November quiz tested your knowledge of the fact that this statement:

DROP PACKAGE

will drop both the package specification and body.

Several players complained that we marked this choice as correct :

DROP PACKAGE plch_pkg
/

DROP PACKAGE BODY plch_pkg
/

As one person wrote: "If you drop the a package and then try to drop the package body, you get the error ORA-04043: object PLCH_PKG does not exist. Answer 8571 is NOT correct."

view counter