Oracle Font APEX – hidden (and undocumented) icons

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

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

Presentations

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

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

Pronounceable password generator in PL/SQL

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

Fully freeware APEX environment VI: Oracle HTTP server (installation)

This is post 6 in my series about a fully freeware APEX installation: Information has been taken from The Oracle Install guidelines http://eelzinga.wordpress.com/2009/07/04/oracle-fusion-middleware-11g-ofm11g-on-centos-5/ Shut down EPG The EPG is still running. To shut it down, open SQL*plus:conn conn system execute dbms_xdb.sethttpport(0); exit Prerequisits Make sure your system has enough memory (2 Gigs or more) We … Read more

Fully freeware APEX environment IV: GlassFish Installation

This is part 3 of my series on a fully freeware APEX environment on CentOS: This post consists of 3 parts: Install Java Glassfish preparations Install GlassFish Configure Glassfish (part 3a) Information has been taken from: http://www.scribd.com/doc/19252518/StepbyStep-Install-Guide-Sun-GlassFish-Enterprise-Server-v3-on-Linux (glassfish part) http://bhapca.blogspot.com/2009/05/how-to-install-glassfish-on-centos-and.html (java part) Here we go… Install Java CentOS allready comes with java pre-installed: /usr/bin/java -> … Read more

Fully freeware APEX environment V: Configure GlassFish

In this post we’ll configure the GlassFish 3 server that we installed in the previous post. Information has been aggregated from different blogs: http://www.davidghedini.com/pg/entry/install_glassfish_3_1_on http://bhapca.blogspot.com/2009/05/how-to-install-glassfish-on-centos-and.html The APEX Listener Installation guide (pdf) Apex & Apex listener download Apex and the listener should be downloaded now. Now we start the admin console and mkdir -p $ORACLE_BASE/product/1.1.2/apxlistener mkdir … Read more