view counter
Home

PL/SQL Feed

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

ACED Nordic Tour 2012: 4 days, 4 countries

Can't believe it's almost two weeks ago. Together with Mark Rittman, Carl Dudley, Sten Vesterli, and Tanel Poder, I was invited to join in for the ACED Nordic Tour.During the Nordic Tour we visited Denmark, Sweden, Norway and Finland.

Nov 07, 2012 7:33am

I Am So Happy

I will start my post-election blog with a picture of my granddaughter:

Nov 07, 2012 5:38am

Buy one, get one free auditing (or The problem with non-transactional triggers)


Click the image for SQL you can run to see the “DML restart” problem in action.

Nov 07, 2012 12:00am

Change Scoring Algorithm for Playoffs?

A player recently wrote the following to us:

I would like to share some thoughts about Playoff rankings. It is not
about my own results, just some thoughts of how to make it more fair. Don't
you think it is not too fair, for example, to answer 100% for 35 mins and finally
lose to one having 80% correctness and a much shorter time (15 min)?

Nov 06, 2012 9:21am

Playing Index Hide And Seek


Click the image for SQL

Nov 05, 2012 12:00am

Oracle 11g R2 Grid Infrastructure installation on 2 node cluster using Virtualbox

Hi Guyzz, Though there is a lot of buzz on Oracle engineered systems, RAC deployments, 12c technical enablements but still certain basics and walkthrough demos appear to be quite handy and helpful for upcoming professionals in the area.

Nov 04, 2012 7:36pm

Doesn't get better than this

Yesterday, visited with Loey and her parents. Got there at 11:30 and Loey still hadn't taken her first nap of the day. We had fun playing for a while, but then I sat down on the rocking chair with her sitting upright in my lap. Rocked slowly back and forth, listening to music, singing quiet songs to her.

Little by little she learned forward, her eyes glazing over....soon she was holding herself just a few inches away from my shoulder...and then her eyes closed and she descended the rest of the way: asleep!

Nov 04, 2012 8:54am

Magically removing your data


Click the SQL for scripts

Nov 02, 2012 1:00am

If I Were Romney

Well, for sure, I wouldn't run for President. Too much baggage. Too much naked ambition, demonstrated by his willingness to change his positions at will, one way or the other just plain lying (most recently shown with his absurdly transparent double-down lies on US automakers.

OK, but clearly he really, really, REALLY wants to be the first Mormon President.

And then Superstorm Sandy hit.

Nov 01, 2012 7:14am

Happy Birthday, Loey!

One year ago, Loey Lucille Silva was born. My first grandchild. So exciting!
 
We had a fantastic birthday party, very impressively organized by Loey-Mom Lauren. Loey had a three hour nap before it started, so she was in fine form throughout, plus there were a half dozen other kids for me to play with, ranging from 10 weeks to 11 years old. Great fun! Here's Loey in her tiger outfit:
Oct 31, 2012 6:27am
view counter