The pre-production release of Oracle APEX 22.1 is just out, and everyone's favorite sandbox, apex.oracle.com, is now running the latest and greatest!
So if you haven't yet abandoned your reading of this newsletter to get your feet wet with the newest features, we'll steal a line from Anton and simply say: THANK YOU, both of you. 😀
Today's edition
APEX 22.1: Quick rundown of some highlights
New post: Tips on declaring stuff in PL/SQL
Community News: Things that caught our attention in the Oracle APEX community.
Early bird is over for Kscope22, but you can still use our $100 discount code!
Upcoming shows: See what's new this week on our Insum YouTube channel.
🎉 Oracle APEX 22.1 is out!
Just because some of us are still waiting for 21.2 to be rolled out on our instances, it doesn't mean we can't get excited about what the next release has to offer, right?
Our own APEXpert Haniel (who has been selected for 2 sessions at Kscope22!) shares some he's particularly excited about below.
Improved Row Search (Favorite ❤️)
Users can now search on multiple words that can be matched across columns. For example, searching for a full name when there are separate first/last name columns in an IR. This has been a "gotcha" for a long time as users simply expect this to work and telling them to only search for one term at a time was counter-intuitive.
Region Sort Page Item
Allows developers to define a set of order by clauses and display user-friendly values to automatically sort regions that didn't previously have built-in customizable sorting, such as Cards, Classic Reports, Charts, and Region Plug-ins.
Persistent Authentication
Allows users to stay signed in even after the session expires. A new session is generated automatically without having to sign again.
Really useful for PWAs, kiosk-like apps, and frequently used apps with frequent daily users.
Effortless App Gallery Installs
This is not really new since we used to have this in versions prior to 21.1, but it's nice to have it back! It can now pull sample and starter apps directly from GitHub to get the latest versions. The UT reference and other sample apps are a gold mine for quick Proof of Concepts.
New capability to add your own Custom Apps to the gallery too for 1-click installs.
Subscription Support for Lists
Single list definition can be shared across multiple apps, really useful for apps with shared navigation.
And although we loved the sample data generation feature of QuickSQL, the all-new APEX 22.1 Data Generator takes sample data generation to the next level. (A little humble brag: we helped build it!)
There is so much more to discover in this new release, we'll be checking it out in greater detail over the next couple of weeks and share our thoughts in an upcoming post.
Tips on 'declaring stuff' in PL/SQL by Steven Feuerstein
Micheal Ferrante, Oracle Senior Principal Product Manager, invites everyone interested in moving Oracle Forms to the Cloud to an Oracle LiveLab workshop entitled "Migrate Oracle Forms to OCI."
Oracle recently launched a new data set repository called Oracle Open Data. It's free and allows you to connect with information from data producers like NASA, NOAA, and NIH, and access a wide variety of data sets, including ZINC, GOES, MODIS and Landsat. See Oracle's explanation in a blog by Andrew Bell.
Need a quick introduction to Oracle Database, SQL, and PL/SQL for your new developers? Connor McDonald points us to this Oracle AskTom resource.
April 26 is Oracle Database World - Americas, a one-day OCI event where you can learn how to simplify data-driven apps and analytics. Register here.
You can still use our Kscope22 discount code!
Take advantage of our $100 discount on regular price registrations for Kscope22. Use this code when registering: INSUM2022. Hope to see you there!
On the Insum YouTube Channel
The Insum YouTube channel features fresh content every week. Join live broadcasts to interact with our experts and get valuable tips!
You might have missed..
On last week's APEX Instant Tips, Anton and Hayden turned a browser-based web service call into a database web service call. Their example uses the APEX Geocoded Address item type to get latitudes and longitudes into the database, but the technique can work for so much more.
