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, or the Search Page.

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.


  • 2021-03-22: "On Wednesday 10 March, we experienced a major incident at our Strasbourg (SBG) site. A fire broke out during the night, affecting many international customers who have data hosted in our Strasbourg datacentres.".
    And guess what: this site was hosted right there! Luckily, out of the four datacenters they have in Strasbourg, my VPS was running on SBG-3. That is the only one they have managed to (partially) restart so far, so since March 21st at 00:39 this website is back online.

Recently Added/Updated Pages

Page IDPage NameLast UpdateDescending
1149(PL)SQL - Source Code Search (SQL)2021-05-05
1135(PL)SQL - Source Code Search (PL/SQL)2021-05-04
1013Apex - General - Items used in PL/SQL2021-04-29
1118Hobbies - Motorcycles - '07 Suzuki Bandit 1250A2021-04-21
1062Hobbies - Motorcycles - '08 Honda Fireblade2021-04-21
1129Apex - General - URLs2021-04-14
1043Hobbies - Motorcycles - '05 Ducati 999 (NL)2021-03-22
1042Hobbies - Motorcycles - '02 Kawasaki ZX-12R (NL)2021-03-22
1041Hobbies - Motorcycles - '00 Honda CBR 1100 XX2021-03-22
  • 1 - 10 of 145


Currently running on:
  • VPS on
  • CentOS 7.9
  • Oracle Database 18c Express Edition Release - Production Version
  • Apex (patch 2020.12.07)
  • ORDS 19.2.0.r1991647
  • Tomcat 7.0.76
The previous setup of a database VM on VMware ESXi, and a reverse Apache proxy VM handling SSL was still running perfectly fine, but in early 2020 I decided to move this website out of the house.