Advanced Web Programming outside of APEX

I finally post the"slides" from my presentation the "Oracle PL/SQL Programming Conference (OPP) 2010 Europe" that took place in Brussels last October.
I think that they have enough info to be interesting.

PL/SQL in TIOBE index continues to go down (February 2011)

PL/SQL is in 33th in TIOBE Index for February 2011. It's was in 23th place in December!
A drop of 10 places in 2 months!

In 2008 and 2007 in February it was in 13th position in the index.

In a previous post I already wrote about some of the reasons that I think is not allowing a better position of the PL/SQL language in this "popularity" index.

Canção ao Lado

Desculpem doutos homens, estetas,
Espíritos poetas, almas delicadas,
A falsidade do meu génio e das minhas palavras.

Que é a erudição que eu canto,
Que é da vida: o espanto, que é do belo: a graça,
Mas eu só ambiciono a arte de plantar batatas.

O que é SYS_REFCURSOR?

Um leitor perguntou-me por mail: o que é uma variavel SYS_REFCURSOR?

SYS_REFCURSOR é declarado no pacote STANDARD (um dos dois pacotes "default" do PL/SQL) e é uma declaração de um weekly typed cursor (cursor com tipo fraco). i.e. IS REF CURSOR

A Google Portugal está activa nos Doodles

(continuação de post anterior)
E hoje é a comemoração do Aniversário de Almeida Garret.

Não deixa de ser educativo e também cria um pouco de distração.

Vitinho no Google

Foi com supresa que vi o Vitinho como Doodle do Google hoje.
Na altura tentei perceber a razão mas não consegui pois estava com alguma pressa.

Agora já sei. Foi para comemorar a data de nascimento do desenho que não era um dado públicamente conhecido.
 No público explicam a origem da ideia e a sua execução.

Second Public Beta of SQL Navigator 6.5

Second Public Beta of SQL Navigator 6.5 (6.5.0.2032) is now available.

Eternal Postponement :-(

Postponement: To delay until a future time; put off.

Oracle SQL Developer Data Modeler 3.0 released

Oracle SQL Developer Data Modeler 3.0 (3.0.0.665) is available.
It includes the ability to create user defined design rules and transformation scripts, integrated reports and support for collaborative development and version control through Subversion.

Check the new features document. Video demonstrations of the new features are also available.

Quest Code Tester for Oracle 2.0 released

Quest Code Tester for Oracle has a new release (2.0) that you can try.
The new features are:

• Redesigned the Main Window: The Dashboard is replaced by a new console window, Test Explorer, that offers much greater usability and functionality.
• Powerful suite management: You can now define suites within suites and set up test workflow with branching logic.
• Multiple Test Definitions Per Program Unit: You can new create more than one test definition for the same program unit. This makes it easier for multiple developers to build and run tests for the same program unit.
• Importing and Exporting From the Database Server: Import and export can now be performed through a PL/SQL API
• New Command Line Utility Separate From Code Tester Executable.

There is a webcast (50 minutes long) of Steven Feuerstein presenting the new features.