"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.
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.
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:
This demonstrates how to create an Java infrastructure for reading and writing large text files to a MySQL database. The example provides:
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.
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:
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
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.
The 7 November quiz tested your knowledge of the fact that this statement:
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."