Ted Struik - Oracle

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.
Over the years I have worked on various Oracle related projects all over the world, and am currently employed by Itium.
Contact me at .

Recently Added/Updated Pages IR

Page ID	Page Name	Last Update
1058	DBA - Access Control List (ACL)	2026-06-29
1190	Hobbies - Focal Onyx	2026-06-09
1173	Apex - Import / Export - apex_export (pl/sql)	2026-04-28
1200	Apex - Reports - Reset button for IR	2026-04-23
1174	Apex - Reports - Get Classic Report query	2026-04-23
1168	Apex - Session State - Request	2026-04-23
1018	Apex - Reports - Use IR results in pl/sql	2026-04-23
1007	Apex - Reports - Download	2026-04-23
1078	Miscellaneous - Links	2026-04-15
1199	(PL)SQL - Creating PL/SQL with LLMs	2026-04-09

1 - 10 of 187

2026-07-06: After running this site on my own server for a few years, I have moved it to an OVHcloud VPS once again.
My server was doing fine, but after about 10 IP changes over the last few years and an internet outage of a few days, it seems like a good idea to let someone else take care of those chores for a while.
Last time I switched (from VPS to my own server), part of the reason was lack of performance of the VPS. I hope that is not an issue anymore - we'll see.