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 #158: Opening multiple browser tabs
Are you concerned about users opening multiple browser tabs? You should be...Marwa and Anton explain.
Read more
APEX #157: Refreshing Region Plugin Regions
Anton and Marwa discuss how to make region plugins regions refreshable. Anton provides a boilerplate plugin...
Read more
APEX Instant Tips #156: Informing users about background processes
Anton and Marwa discuss Background processes: informing users of what is happening and what occurs upon...
Read more
APEX Instant Tips #155: About icons and buttons builder
We have extended the Universal Theme application to allow more customization within the icon and button...
Read more
APEX Instant Tips #154: How to Recenter a Map Region
What is this episode about? Hint: Initial position in zoom, isn’t enough…
Read more
APEX Instant Tips #153: Everything you always wanted to know about combobox but never thought to ask
With Combo boxes, you must manage your business rules and watch for multi-user concurrency issues. Anton...
Read more
APEX Instant Tips #152: APEX.debug
In this episode, Anton and Marwa compare Console.log, APEX_debug.log, APEX_debug.message, and APEX.debug.setlevel.
Read more
APEX Instant Tips #151: Updates to tips 148, 146 & 53
A review and update of 3 previous instant tips: Checksum, Faceted Search, and Multilingual Apps from...
Read more
APEX Instant Tips #150: Rarely Used Region Types (RURTs)
Different Region Types, including the Toggle Column Report Region, Avatar Region, Reflow Region, and Smart Filters.
Read more
APEX Instant Tips #149: APEX Dev Team Magic: APEX Item Plug-in
Anton and Marwa show you a magical query. No matter what type of LOV definition you...
Read more
APEX Instant Tips #148: Protect Ajax Callback processes from hacking
Last week, we made it easy to use Ajax Callback processes. This week, we show how...
Read more
APEX Instant Tips #147: Why are Ajax Callback processes so hard to use?
Ajax callbacks are hard to use: Learn the javascript and be careful about syntax. Marwa and...
Read more
APEX #146: APEX Instant Tips #146: Extending Faceted Search
Hosts Anton and Marwa talk about how to make a page item look and behave like...
Read more
APEX Instant Tips #145: How to know if the data in your Interactive Grid row changed
:APEX$ROW_STATUS is a pseudo column that can be used in PL/SQL, just like any other interactive...
Read more
APEX Instant Tips #144: When to_date
To_date, To_number, and To_timestamp stem from how APEX stores and treats Session State. Anton and Marwa...
Read more
APEX Instant Tips #143: Javascript and css from pl/sql
In this episode, Marwa and Special guest Eglé describe how to add javascript code and CSS...
Read more
APEX Instant Tips #142: LOV additional columns
Michelle sits in for Anton this week as Marwa shows you how to leverage additional columns...
Read more
APEX Instant Tips #141: The APEX qAsk application
The APEX qAsk application can be used for live surveys. Anton and Marwa demonstrate and point...
Read more
APEX Instant Tip #140: A tip for when merging working copies
When merging a copy back into an APEX app, make sure to unclick anything that says...
Read more
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 more
APEX 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 more
APEX 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 more
APEX 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 more
APEX 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 more
APEX 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 more
APEX 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 more
APEX Instant Tips #132 AuthN vs AuthZ
Anton and Marwa talk about the difference between Authentication and Authorization in particular when applied to...
Read more
APEX 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 more
APEX Instant Tips #130: Downloading files (mostly) declaratively
Anton goes solo this week and shows us a declarative way to Download files. His Off...
Read more
APEX Instant Tips #129: Roll with it. ThemeRoller that is.
Using ThemeRoller and CSS variables to create a cohesive user experience.
Read more
APEX 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 more
APEX Instant Tips #127: VSCode Snippets
VSCode is an editor of choice, but if you have PL/SQL code that you edit in...
Read more
APEX 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 more
APEX 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 more
APEX 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 more
APEX 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 more
APEX Instant Tips #121: APEX Utilities Everywhere
In this episode, Anton and Michelle discuss the complexities of finding the utility in APEX that...
Read more
APEX 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 more
APEX Instant Tips #119: APEX Debug Trivia
What happens with APEX Debug? What ends up in the log? Find the answers to...
Read more
APEX 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 more
APEX Instant Tips #117: Global Meta Search
Leveraging APEX Metadata within new the new APEX 22.2 feature called Search Configurations. Useful links included.
Read more
APEX 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 more
APEX 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 more
APEX 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 more