APEX Instant Tips with Anton Nielsen and Marwa Chouchene
Think you can’t learn anything valuable in 5 minutes? Anton and Marwa will prove you wrong, on APEX Instant Tips most Fridays at 12:05 pm EDT
A different Oracle APEX tip every week. Join us!
Upcoming Episodes
Make sure you catch our upcoming events!
Past Episodes
APEX Feature Requests inspired by the show!
Highlight changed items for “Warn on Unsaved Changes” (Link to episode) | FR-1902 |
Enable “Plain Text (based on List of Values)” as an option when configuring the “Cards” region columns (Link to episode) | FR-2148 |
“Automatic Time Zone” should use “Time Zone Region” not UTC (Link to episode) | FR-2138 |
Make Relevance Score available to LOVs that use Oracle Text (Link to episode) | FR-2123 |
Remove Build Option from Associated Components directly from the Build Option page (Link to episode) | FR-2110 |
Add a declarative “Commit Upon Success” attribute to processes (Link to episode) | FR-1894 |
Document “apex_plugin_util.is_component_used”(Link to episode) | FR-2240 |
Ability to set “Clone APEX Session When Opening New Tab/Window” at the application level (Link to episode) | FR-2886 |
Previous episodes
Latest News/ View All
APEX Instant Tips #139: How to hide inactive rows in an LOV _unless_ the record has that value
Every APEX user can appreciate this. Once you get there, the route seems obvious, but most...
Read moreAPEX Instant Tips #138: How to read & understand the help for PopUp LOV JS Initialization Code
Anton and Marwa discuss how to read and understand the help for PopUp LOV > Javascript...
Read moreAPEX Instant Tips #137: How many APEX developers does it take to screw in a lightbulb?
Anton explains why all your tables with foreign keys should have an index on the foreign...
Read moreAPEX Instant Tips #136: Expertly crafted with love by Insum using Oracle APEX
From creating text messages in the shared component application (tip #86) to how you can change...
Read moreAPEX Instant Tips #135: It’s valuable for developers to understand the APEX Infrastructure
It's important to understand how ORDS handles the connection pool and connection security. ORDS connections to...
Read moreAPEX Instant Tips #134 : Weighted Page Performance reporting in Dev, in UAT, and, oh yeah, in Prod.
Anton and Marwa go over 3 interesting tips on Weighted Page performance that can be used...
Read moreAPEX Instant Tips #133: Tiny Tips for Teams Tackling Tasks Together
Quick tips to customize your APEX Workspace, Anton adds his Wisdom of the week: "Step back...
Read moreAPEX Instant Tips #132 AuthN vs AuthZ
Anton and Marwa talk about the difference between Authentication and Authorization in particular when applied to...
Read moreAPEX Instant Tips #131: Making responsive design respond as it should
Anton demonstrates how to alternately load 2 versions of the same report depending on screen size,...
Read moreAPEX Instant Tips #130: Downloading files (mostly) declaratively
Anton goes solo this week and shows us a declarative way to Download files. His Off...
Read moreAPEX Instant Tips #129: Roll with it. ThemeRoller that is.
Using ThemeRoller and CSS variables to create a cohesive user experience.
Read moreAPEX Instant Tips #128: Explore the Depths of Deep Linking
Yes, you can have session state protection enabled and send deep links via email. Anton and...
Read moreAPEX Instant Tips #127: VSCode Snippets
VSCode is an editor of choice, but if you have PL/SQL code that you edit in...
Read moreAPEX Instant Tips #126: Making Markdown Work the Way We Want It To
In this episode, Anton and Hayden explain how to get markdown links to open in a...
Read moreAPEX Instant Tips #125: A Solution for a Data Packager Issue – Special Guest Jayson Hanes
Anton and Hayden share their solution for an APEX Data Packager bug with special guest APEX...
Read moreAPEX Instant Tips #123: Often overlooked – APEX Access Control Lists
Another feature we often overlook: APEX Access Control Lists (ACLs)...or, the difference between Authorizations and Roles
Read moreAPEX Instant Tips #122: Static LOVs for Benefits Beyond Standard APEX Components
APEX LOVs can be used in custom components such as plug-ins, PL/SQL regions, and more. Anton...
Read moreAPEX Instant Tips #121: APEX Utilities Everywhere
In this episode, Anton and Michelle discuss the complexities of finding the utility in APEX that...
Read moreAPEX Instant Tips #120: Another reason to use Template Components
What can you do with Template Components in 5 minutes? Anton and Hayden build one to...
Read moreAPEX Instant Tips #119: APEX Debug Trivia
What happens with APEX Debug? What ends up in the log? Find the answers to...
Read moreAPEX Instant Tips #118: Fidgeting with APEX Interactive Report Widget
Anton and Hayden show you how to improve your UX options in Interactive Reports using APEX...
Read moreAPEX Instant Tips #117: Global Meta Search
Leveraging APEX Metadata within new the new APEX 22.2 feature called Search Configurations. Useful links included.
Read moreAPEX Instant Tips #116: Breadcrumb Redux: The Super Breadcrumb region plug-in
Following up on episode 114, Hayden introduces Anton's new Super Breadcrum region plugin, which includes a...
Read moreAPEX Instant Tips #115: Show a success message on dialog close
Sure, showing an success message on dialogue close should be just an APEX feature, but it's...
Read moreAPEX Instant Tips #114: More on making the most of a Navigation Menu
Anton demonstrates his plugin to go from a navigation menu to a breadcrumb.
Read moreAPEX Instant Tips #113: How to merge data during application deployement
Hayden describes how one can merge from the zipped static file that Data Packager creates for...
Read moreAPEX Instant Tips #112: Always filter APEX views by workspace_ID
Filtering APEX views by workspace_ID has the advantage of making your results more intuitive as well...
Read moreAPEX Instant Tips #111: How to masquerade as another user
Anton and Hayden demonstrate how to test authorization schemes effectively by masquerading as another user.
Read moreAPEX Instant Tips #110: Debugging the JavaScript keyword “this” when used in APEX dynamic actions
Anton and Hayden discuss debugging the JavaScript keyword “this” when used in APEX dynamic actions using...
Read moreAPEX Instant Tips #109: Writing Fast Queries Part 1
An overview of several tips from Anton's blog post about writing fast queries and a demo...
Read moreAPEX Instant Tips #108: Basic Liquibase
Built into SQLcl for everyone to use is Liquibase. Hayden demonstrates his preferred method for its...
Read moreAPEX Instant Tips #107: APEX Session Overrides
Session overrides is an APEX feature that enables you to code in local files that affect...
Read moreAPEX Instant Tips #106: A few pointers on SQLcl
Using their 5 minutes to its max (and then some), Hayden and Anton discuss Formatting and...
Read moreAPEX Instant Tips #105: Make your APEX application SEO friendly
In this episode, how to get search engines interested in your APEX pages despite their distaste...
Read moreAPEX Instant Tips #104: Alternative methods for hiding and showing columns
Hayden and Anton explore methods for hiding and showing columns including serverside condition, dynamic action "hide"...
Read moreAPEX Instant Tips #103: Three Interactive Report tips
in 5 minutes, Anton and Hayden take us through 3 useful tips 1. How to shorten...
Read moreAPEX Instant Tips #102: on “Prevent Lost Updates,” “Lock Row,” and “ListAgg.
Anton and Hayden take you as deep as they can go in 5 minutes on "Prevent...
Read moreAPEX Instant TIps #101: 3 gripes about APEX
In this episode, Anton and Hayden unpack 3 gripes they have about APEX and include some...
Read moreAPEX Instant Tips #100: Extra Sketchy Tip!
Hayden and Anton have held onto this "extra sketchy" tip for quite a while. It's worthy...
Read moreAPEX Instant Tips #99: Connecting an APEX app to GPT-3
Anton and special guest Michelle Skamene show you how to create a GPT-3 REST Data Source...
Read moreAPEX Instant Tips #98: An easier way to give secure access to a REST enabled schema
Anton describes how to give access to a REST-enabled schema by simply granting the SQL developer...
Read moreAPEX Instant Tips #97: What should :APP_USER contain?
For active APEX users, switching user names can be a major inconvenience. Anton recommends setting APP_User...
Read moreAPEX Instant Tips #96: monitor your query with automations
In this episode, Anton and Hayden recommend trying automations when IR subscriptions don't quite meet your...
Read moreAPEX Instant Tips #95: Making the most of a navigation menu
Anton and Hayden provide an efficient solution for how to replicate the redundant menu design pattern...
Read more