view counter

PL/SQL Feed

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

Poor, Sad Website: Voiding Today's Quiz

At 9:45 AM Chicago time, the PL/SQL Challenge website became unresponsive. It looks like we were and are being hammered by bots. We have been unable to stop the onslaught and so after a few hours of on again, off again access, I must announce with great sadness that we will void the results for today's quiz.

This means they will not be included in rankings for the quarter.

Now, having said that, I plan - when the site and backend become available again - to see how easily we can extend the end date for today's quiz....to tomorrow (make it a "two day quiz").

Temporal validity(history) in Oracle 12c

In Oracle 11g You can store the previous states of the a table in a Flashback Archive.
Now, starting with Oracle 12c, You can store the old and current states of the rows in the same table.
This is extremely important for dimensonal tables in a Datawarehouse,
because we may want to keep the whole history of a dimension table.
(Consider SCD2 Dimensions)
We can explicitly or implicitly define date/timestamp type columns
that are responsible to store the “lifetime” period of a particular row.

SQL Brainteasers: Guess the Christmas Carol/Song

Christmas is approaching, so some Christmassy-themed songs to guess. Seven to get this time (because it’s Chrismtas ;). As always, put your answers in the comments!

PL/SQL Quiz: How can we stop this function raising NO_DATA_FOUND (without changing it)?

Another puzzle, when we execute the function below it returns NO_DATA_FOUND because the table is empty:

See you all in Seattle

In June 2014 I hope to see a whole lot of you at ODTUG's awesome conference Kscope14...

Compounding the problem for updates

A compound trigger curiousity I found recently:

DOS Attacks!

select description
from dos_attacks

DESCRIPTION
--------------
System crippling denial-of-service hacks
The revenge of a Microsoft OS

DOS Attacks sounds like a bad sci-fi movie waiting to be made.... ;)

select posts from sqlfail

Daily Quizzes Will Continue in 2014

I am very pleased to announce that I have decided to continue the daily PL/SQL quiz in 2014.

There are two reasons for this change from my earlier plan to terminate the daily quiz.

First, I realized that I hadn't made it as easy as I should have to write and submit quizzes. I never really gave you, my dear players, much advice about how best to write a quiz, and the Submit Quiz wizard requires too much effort on your part.

Invisible Not Null Column

Yesterday I attended John King (@royaltwit) session on Oracle 12c for developers. He gave an overview of all the goodies that are available to us as developers. The whole plugging and unplugging of database, though very cool and exiting, is most likely not very relevant to most developers.

Building Your Own ORM

create view of_your_tables_so_it_is
of an_object
with object oid (your_relational_data) as
select
your_relational_data,
into_an_object_model
from your_relational_tables;
I'm not sure whether or not this approach is "better" than using Hibernate or other object-relational mapping tools.
At least you have a better idea how the mapping works by looking at the database I guess.
For further reading on this, have a look at <

view counter