Search for a command to run...
Articles tagged with #oracle
Introduction This is a quick tip if you are still using the APEX_ITEM.CHECKBOX2 function embedded in your reports' SQL. SELECT APEX_ITEM.CHECKBOX2(P_IDX => 10, P_VALUE => ID) AS CHKBOX, ...... FROM
Have you ever needed to see exactly what the user is seeing in an interactive report (IR) or grid (IG) in their current session? You obviously know what query/view/table you used to create the IR or I
There are many excellent blogs already out there that explain what execution chains are and how to use them in Oracle APEX and I encourage those unfamiliar with the concept to read them. What I will say is that, in my opinion, their biggest advantage...
How to make a common "landing page" in Oracle APEX that presents child navigation menu options as a card region that updates automatically as entries are added or removed. I initially published this as a stand-alone article on LinkedIn but decided it...
Virtual columns were introduced in Oracle 11g to conveniently include computed logic directly in a table, appearing just like any other column. The expression used must be deterministic, meaning it must always produce the same result given the same i...
There are many fantastic blogs about using Oracle 23ai as a powerful tool to take advantage of the growing interest in artificial intelligence. For example, the excellent Oracle ACE Jonathan Dixon has a website that collects blogs related to Oracle, ...
