DB2 now provide native support for PL/SQL!

Wow!

Great news that I was not expecting:
PL/SQL is now support in DB2 (since version 9.7)!
(I was expecting the next database to use it would be MYSQL!)

Hallelujah

A letra com tradução em itálico

Oracle 11g release 2

The Linux versions is already available!
Link for the documentation.

Discurso de Steve Jobs em Stanford

Atualização (outubro 2011): Steve Jobs has passed away but his work, and his life lessons carry on!

Uma entrada de casamento diferente

Steven Feuerstein na FEUP

Steven Feuerstein (Guru em Oracle PL/SQL) vai voltar a Portugal
Dia 21 de Setembro de 2009 no Porto
Faculdade Engenharia da Universidade do Porto

Para se registar gratuitamente envie um email para steven2009@dutec.pt com o seu nome, morada e telefone.
O evento realiza-se durante a manhã do dia 21 de Setembro de 2009 no Auditório da Faculdade Engenharia da Universidade do Porto

Para mais informações contacte a DUTEC através do número 21498 67 80

SQL Navigator 6.2 released

SQL Navigator 6.2 was released

Some new features:

• New Search feature for the Preferences window.
• Preference to format after extracting the ddl.
• Import/Export tables.
• Session browser to support RAC database.
• Revised layout to accommodate multiple code editor windows.
• Code Editor - Bug fixes and enhancements.
• Other General bug fixes and enhancements.

TIOBE Programming Community Index for July 2009

PL/SQL in 12th (was 13th in July 2008) in the TIOBE programming community index

Mosquito - Loco Loco

Aqui fica a letra da música que o meu filho (quase a fazer dois anos) quer sempre ouvir no carro.

Is NVL really slower?

I recently found this tip.

Small "abstract": the use of a verbose to compare values including null values is faster than the use of nvl, or even coalesce. An NVL is must slower than the other two options!

I wanted to try it in 11g (Oracle Database 11g Release 11.1.0.7.0 - 64bit Production)
I show here the code of that article but cut-paste friendly :-) (So you can try it by yourself)