Happy Twosday! No matter how you see today's date (2022-02-22, 02/22/2022, 22/02/2022), it makes for a good water-cooler fact, don't you think?
Especially if you congregate at 2:22? 😀
While many of us aren't quite back to the office and exchanging fun facts yet, we are starting to look forward to some semblance of normal again. Kscope is back with its first in-person event in 2 years, and we're thrilled to be a part of it!
This week's edition
Blog post: Insum at OTDUG Kscope22 - See you there?
Community news: Things that caught our attention in the Oracle APEX community.
Awesome Quick SQL Tip by Chris Saxon!
Upcoming shows: See what's new this week on our Insum YouTube channel.
The latest interview in the Women in APEX #WIT series features Andreea Munteanu. To learn more about Andreea and all the other awesome Women in APEX, read the blog!
If you missed last week's Office Hours about Vanity URL Extensions for APEX and ORDS on Oracle Autonomous Database, you can find the recording here.
Our very own Adrian Png apparently never sleeps and shared what happens when you put Oracle APEX and the recently launched OCI AI Vision service together and created a simple travel receipt management app. Check out the preview 😍:
💡 APEX App Creator Spotlight: In the latest edition of this great series, check out how HOMR acts as a workforce multiplier for datasets used to understand the trajectory of climate change with 🌟 APEX Rockstar Shelley McNeill.
We loved Chris Saxon's recent tip about using partitioned outer joins. Huh, you say?
This is useful, for example, to get a row for every product for every day in a period, including days each product had no sales.
We see this sort of use case a lot and have come up with less elegant solutions to solve them. Thanks, Chris! Check out his SUPER quick how-to video here.
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!
Missed last week?
Last Friday on APEX Instant Tips, Anton showed us some interesting things you can do with a function called apex_session.attach. His guest was none other than Hayden Hudson! We're not going to say Hayden will become a permanent fixture on the show, but we're pretty confident we can wrangle a few more guest appearances out of him in the coming weeks😊.
Moved to Next week
Feuertips, initially scheduled for tomorrow, has been moved to next Wednesday, Mar. 2. Steven will be talking about writing - and fixing bugs in - dynamic SQL.
%20(260%20%C3%97%20260%20px).jpg?upscale=true&width=520&upscale=true&name=YouTube%20Thumbnails%20(Twitter%20Post)%20(260%20%C3%97%20260%20px).jpg)
