view counter


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

Auditing your changes

Click the image for scripts

A Conversation with Teenagers

I was invited by a friend to talk with a group of teenagers about what it's like to be a computer programmer and why they might want to do the same. There were over 50 kids present, ranging in age from 12 to 18. They were great fun: enthusiastic, curious and engaged.

I decided to go light on the actual programming aspect (what code looks like, how you write it) and instead take a fairly big step back/up and talk about some big picture challenges. And to avoid boring these over-entertained kids out of their skulls, we played games - Mastermind and Set. They really enjoyed that.

Q3 2012 Playoff on 24 October

The next quarterly championship playoff (for Q3 2012) will take place on Wednesday, 24 October. Forty-five players have qualified to take five tough quizzes in forty minutes. Wish them luck!

Here's some background on the players in the upcoming playoff, including the number of playoffs in which they've already played; their rank in that quarter, their rank in the playoff, and their best playoff performance.

Making Eclipse IDE Supports JSF 2.0

Autocomplete was not working for JSF tags in my Eclipse. I googled it and finally found the solution on

Thanx Mkyong.

The different thing I did is; I downloaded javax.faces-2.xx.xx.jar and saved in a specific folder. Then I created a user library with this jar. I did not use “jsf-api-xxx.jar and jsf-impl-xxx.jar“.

Using lookup tables

My students wanted an example of how to use a lookup table in the database. I thought it would be a great idea to create a simple example like this one.

A lookup table is a generalization that holds lists of values that support end-user selections. The following example uses a combination of the common_lookup_table and common_lookup_column columns to identify sets of value for drop down lists. The end-user selects a value from the list to identify a unique row, and returns a common_lookup_id surrogate key value.

Generally, most people prefer getting things now

Present bias and procrastination affect us all – see this excellent article to see why

RANGE BETWEEN and leap years

Answering a question on the OTN forum was a bit tricky to get an analytic sum using a RANGE BETWEEN that would handle leap years, but in the end I came up with a workaround that satisfies the requirement. Along the way I realized why there are two different INTERVAL datatypes :-)Let's make a sales table to demo this:create table sales ( day date , qty number)/

OOW 2012: Little things make me happy

Yesterday evening we had the annual "We went to OOW and this is what's new in the world we call Oracle" at AMIS. Starting around 5pm and ending around 10pm a lot of information was presented by several AMIS colleagues.My contribution to the evening was (amongst others) a little bit of new features in SQL and PL/SQL, only a little bit as there is too much to cover in just 20 minutes. It's the little things that make me happy. What is the little thing that I like?When you define a table you can assign a default value to a column (here it comes) based on a sequence.

Find your way with HttpUriType and Google Maps

Recently I read Duke Ganote writing about using UTL_HTTP to get stock quote from Yahoo. (Duke must have a thing for authorities, particularly Marshalls of Legoredo ;-) Anyway, I posted a comment how to do a similar thing with HttpUriType.

view counter