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 #162: About Display Only Items in Oracle APEX
In this week's tip, any time you set a value in the browser, a user could...
Read more
APEX Instant Tips #161: More about hashing than you could possibly want to know…but you should.
Marwa and Anton take you through hashing and checksums. Maybe more than you could possibly want...
Read more
APEX Instant Tips #160: APEX utilities you may never need, but if you do, they’re good to know.
Anton and Marwa show you the utilities you can find in APEX Object Reports, and there...
Read more
APEX #159: Recipes from the IG Cookbook
Marwa and Anton show you amazing things you can do with an Interactive Grid through recipes...
Read more
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