PL/SQL

I am a PL/SQL nerd. I love the language and what you can do with it. I consider myself a PL/SQL programmer first and only secondarily an APEX developer. For quite some time now I am highly in favour of using Object-Oriented techniques within packages but have difficulties convincing others Read more…

By Richard Martens, 2 months7 April 2022 ago

APEX JavaScript PL/SQL

And that’s how the cookie crumbles

owa_cookie.send does not write the cookie to the browser because the “Reload on Submit” setting is not set at page level.

By Richard Martens, 4 years1 November 2018 ago

APEX PL/SQL

On APEX LOV’s and how to define their queries

The goal in defining LOV queries is to have them stored in a compiled way, having the benefit of database dependencies and making use of the SQL optimizer.

By Richard Martens, 4 years13 October 2018 ago

PL/SQL

A good example of PLSQL-OO

APEX JavaScript PL/SQL

And that’s how the cookie crumbles

APEX PL/SQL

On APEX LOV’s and how to define their queries