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.
Can you guess the film titles suggested by these SQL clues? As always, put your answers in the comments!
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…
set sqlterminator ?
set sqlterminator !
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! ;)
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.
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: