@jkerr
Delivering real value with innovative strategies and solutions
Specializing in innovative, visionary and strategic application of technology to create value and solve real world problems through a virtual CIO client-service model. Services include vision and strategic planning; creative problem solving and process optimization; application architecting, Oracle database & PL/SQL, Oracle APEX, Forms migration, and web design, build, and support. Experienced certified Oracle Database Administrator, Oracle Cloud Infrastructure, and Linux system administration team as well.
Creating vision, strategies, and solutions that add value to organizations and assist with competitive differentiation.
Nov 26, 2025 · 10 min read · Context Oracle foreign key constraints in database tables ensure referential integrity between two tables. This means that a column value in one table must match at least one value in the other table, or the column value can be null. For example, if...
Join discussion
Jul 2, 2025 · 3 min read · Context Shuttle Lists are an APEX Page Item type that allows users to easily select multiple items by moving them between two panes. The Shuttle List source is a custom two-column SQL query that displays values and includes a referenceable primary ke...
Join discussion
Jun 1, 2025 · 5 min read · Context APEX_Mail is a versatile Oracle APEX function for sending e-mail from APEX applications using PL/SQL. APEX Mail’s many parameters and options make it easy to call from anywhere without needing additional functions. But is that what you want? ...
Join discussion
May 24, 2025 · 5 min read · Context APEX Custom Authentication is a component of APEX applications that activates when a user signs in. It allows you to create a user validation/authentication function using PL/SQL logic, returning TRUE if the user is authenticated and FALSE if...
Join discussion
May 12, 2025 · 30 min read · Context Logging data changes in Oracle tables is crucial for troubleshooting, meeting regulatory and organizational requirements, and providing customer service. Change Data Capture, Streams, and Log Miner were once possible built-in solutions, but O...
Join discussion
