Skip to Main Content

Oracle Database & APEX development, advice and support

Ted Struik - Oracle Development

Mnemonics for Oracle SQL, PL/SQL & Apex

A collection of notes, ideas, solutions, bug fixes, best practices, thoughts and reminders, related to Oracle SQL, PL/SQL & Application Express (Apex).
I couldn't resist putting in some hobbies as well.
Navigate using the menu, the Site Map, the Search Page, or the Search field in the navigation bar.

IT became a hobby of mine around 1980, and turned into a profession in 1994. Oracle came into view around 2000.
Based in The Netherlands, I'm involved in various Oracle related projects all over the world.
After running my own company for the past few years, I now have a permanent job with Itium. More details can be found in my Curriculum Vitae.
Contact me via or LinkedIn.

Recently Added/Updated Pages

Page IDPage NameLast UpdateDescending
1073Miscellaneous - VMware2021-11-25
1075(PL)SQL - Apex_string.split in SQL2021-11-25
1029Apex - Session State - About Session State2021-11-17
1127(PL)SQL - JSON2021-11-09
1107Apex - General - Database Dependencies2021-11-05
1070Apex - General - Version2021-11-03
1013Apex - General - Items used in PL/SQL2021-11-02
1153Apex - HTML / CSS / JavaScript - RequireJS2021-11-01
1086Apex - HTML / CSS / JavaScript - Codemirror2021-11-01
1084Miscellaneous - Windows2021-10-30
  • 1 - 10 of 148


  • VMware ESXi 6.7
  • Oracle Linux 8
  • Oracle Database 21c Express Edition Release - Production Version
  • Apex 21.1.5 (patch 5)
  • ORDS 21.2.4.r2431032
  • Tomcat 9.0.53
  • Database is up since 2021-11-07 00:06:55
In October 2021 I moved this website back to my VMware ESXi server, after running for about 18 months on a VPS at That VPS worked fine, but VMs on my own server make things more flexible, and the site performs better as well. And my server is running 24/7 anyway, so why not save some money as well? :-)
I also changed the OS (from CentOS to Oracle Linux), and updated the XE database, Apex, ORDS and Tomcat, so it's all brand new and shiny.
More info on the VM setup: database VM on VMware ESXi, and a reverse Apache proxy VM handling SSL.