Anton shares his plugin for getting Oracle APEX IG data into a page item. Once the data has been passed to the item, you can use it in Dynamic Actions, as the source for a classic report, and more.
Useful Links
Link to plugin: https://github.com/ainielse/get_ig_data
Link to Yvonne’s post on time zone handling and hours in a day: https://yvonnebakx.wordpress.com/2022/03/18/pl-sql-hours-of-day/
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #85: Using APEX Data Generator
Generating good representative data in a dev environment is key. In this episode, Hayden takes us...
Read more
APEX Instant Tips #84: Timestamp with Time Zone – Anton solves another APEX bug!
Anton and Hayden take you through the resolution of a Timestamp with Time Zone bug in...
Read more
APEX Instant Tips #83: Your custom tasks in the Insum APEX Starter Project Template
Customize the task menu in the Insum starter template for your project's custom needs. your...
Read more
APEX Instant Tips #82: Add Feature Page & Manage Backups
In this quick double-feature Friday, Anton points out that "Add Feature Page" is now accessible in...
Read more
APEX Instant Tips #81: Use Oracle SYS_CONTEXT in your APEX Application PL/SQL Initialization Code
Anton and special guest Plamen Mushkov discuss the advantages of SYS_CONTEXT and how to utilize a...
Read more
APEX Instant Tips #80: How to assert business rules for your PL/SQL.
In this episode, Hayden covers how to assert business rules for your PL/SQL using a package...
Read more
APEX Instant Tips #79: Insum APEX Pro Chrome Extension for Developers
Ben Shumway joins Anton and Hayden to show how Chrome extension Insum APEX Pro can make...
Read more