view counter


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

More Date Mysteries: When Is Current SYS?

If you work with clients with in different timezones, be wary of the CURRENT_DATE/CURRENT_TIMESTAMP functions:

First-ever Tree Rescue Day - November 16

I invite all my friends and concerned strangers (though not for long, if you show up!) to participate in my first-ever Tree Rescue Day, on Saturday, November 16, from 10 AM to 12 PM, in Rogers Park, Chicago.

Trees - towering above us, living far beyond our small lives - shouldn't need our help, but they do. We humans, in our relentless quest for convenience and comfort, carelessly transfer species (plants, insects, animals, bacteria) around the world, disrupting the ecological balance established through millions of years of evolution.

SQL Brainteasers: Guess the Film Part 7

Can you guess the film titles suggested by these SQL clues? As always, put your answers in the comments!

Reflections on Starting the Database Design Quiz

select my_thoughts
from starting_the_db_design_quiz;

As regular readers will know, last month saw the start of the Database Design Quiz on the PL/SQL Challenge. I thought I’d share some of the background on how this came about and my thoughts and feelings on how it’s going, so here goes…

SQLTerminator: Not as Cool as the Real Terminator

set sqlterminator ?

select queries
from your_database?

Become questions

set sqlterminator !

select queries
from the_database!

Become exclamations!

You need to run in SQL*Plus to use this. I can’t think of a particularly good use – other than playing tricks on your colleagues! ;)

Oracle Database 12c PRAGMA UDF and WITH clause enhancements

Here are two interesting enhancements in Oracle database 12c PL/SQL. PL/SQL subprogram defined using WITH clause of a subquery – Oracle database 12c allows PL/SQL declaration section in the WITH clause. One can define PL/SQL function or procedure into a WITH clause.

Just another SQL beautifier

Previously i wrote beautifier in perl, but it was not so good, so i decided to write it in java using popular BlancoSQLFormatter library.
So you can download it now:

Column Re-ordering: The Hard Way and the Easy Way

If you want the colums in your tables to appear in a different order, you can clone the table, drop the old and rename the new:

SQL Brainteasers: Another Batch of Films to Guess

These are proving popular, so here’s another six clues to films. If you’d like to catch up on the previous ones, have a look at the quizzes tag. As always, put your answers in the comments!

Foreign Keys and the Database Design Quiz

As regular readers will know, two weeks ago marked the launch of the database design quiz on the PL/SQL Challenge, a quiz conceived and authored by me.

view counter