Richard Martens

Richard Martens has been involved in information technology for more than 20 years. He started as a web developer using the Oracle database as no more than data storage. Richard has been responsible for major European multilingual websites and has been working with the Oracle database since 2000. During those years, he developed himself using a multitude of technologies and specialized in PL/SQL and Oracle APEX. With APEX, he combines the things he loves most: the Oracle database and web technologies.

Oracle Font APEX – hidden (and undocumented) icons

by

I love the Font APEX icons. Hundreds of icons free to use in any APEX application. Since it is also present on GitHub (https://oracle.github.io/font-apex/index.html) you can even use them in a non-apex application. I use Google authentication a lot, and always used the fa-google icon on the button that allows such authentication. Without even thinking … Read more

Oracle Font APEX icon builder

by

Yes, I advised everyone to use the Universal Theme sample application to build their icons. Its convenient, we can copy all our classes, change the behaviour of the icons and what not. We should all love that, and we do. However, I did found an alternative that has a better response time (the UT app … Read more

PL/SQL-OO an object oriented approach to a table-api

by

It is time for me to start publishing some “old” material. Old material, indeed, however still relevant. I won’t be publishing irrelevant stuff. That seems a wast of my and your time.. Work is busy enough to waste time. The above presentation grew from a knowledge session at SMART4Solutions. The intention was to introduce my … Read more

Presentations

by

Date Conference City Title 18 Dec 2023 SPOUG online PLSQL-OO an object oriented approach to table APIs 2 Jun 2023 SIOUG Portoroz Understanding auto-rest (ORDS on steroids) 1 Jun 2023 SIOUG Portoroz APEX Application lifecycle with feature based deployment 3 May 2023 APEX Connect Berlin APEX, PLSQL and RESTful services II: Consuming Secure Services 3 … Read more

a trip down memory lane

by

I cannot however publish a blog post where our friend Joel is mentioned without reflecting on the relationship I had with him. The first time I met Joel was at the OGH (now NLOUG) conference APEX-World in Zeist. I think it was the last time the conference was held at the Figi Hotel there. I … Read more

Celebrating Joel Kallman Day: Honoring a Remarkable Legacy

by

My laziest post EVER (all except the last chapter generated by ChatGPT)I marked all incorrect data like this Introduction On the second Tuesday of October, individuals from all corners of the world come together to celebrate Joel Kallman Day, a special occasion dedicated to honoring the memory and accomplishments of a remarkable individual. Joel Kallman, … Read more

Pronounceable password generator in PL/SQL

by

How often do I need to generate a password for one of my database users and colleagues? Here is how I do that. function auth_pwgen return varchar2 is l_pos integer; l_pw varchar2(100); l_c varchar2(100) := ‘bcdfghjklmnprstvwz’; –consonants l_v varchar2(100) := ‘aeiou’; –vowels l_a varchar2(100) := l_c || l_v; –both l_s varchar2(100) := ‘!@#$%^&*()’;begin –use three … Read more

ConTech by RoOUG 2022 

by

We’re always happy to help conferences with a mobile Conference App to use on their conferences. Most of all when the conference is small or new. It just feels good to help people out. Especially when these people share the same interest. For us that is Oracle in general and more specific APEX. We’re an … Read more

A good example of PLSQL-OO

by

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 to share that position. In … Read more