Louis Moreaux's Avatar

Louis Moreaux

@moreaux-louis

Oracle ACE Pro ♠ Senior APEX developer at @oracletechtalan.bsky.social Flows for APEX contributor - https://flowsforapex.org I love building apps with #orclapex and share my findings on my blog lmoreaux.hashnode.dev

637
Followers
655
Following
172
Posts
17.07.2023
Joined
Posts Following

Latest posts by Louis Moreaux @moreaux-louis

Merry Christmas to all my friends in the #orclAPEX and #Oracle communities 🎉🎄✨

25.12.2025 11:24 👍 5 🔁 0 💬 0 📌 0
Post image

The #EastCoastOracle Conference starts tomorrow! Catch @richsoule.bsky.social sharing insights alongside Oracle experts and community leaders.
Learn more here: www.eastcoastoracle.org

#Oracle #orclapex #OracleCommunity

03.11.2025 17:00 👍 2 🔁 2 💬 0 📌 0
Post image

Just got my #OracleACE swag — including an umbrella that arrived right on time for the “beautiful” Paris weather! ☔🇫🇷

Thanks to the @oracleace.bsky.social team (@oanabonu.bsky.social, Cassandra Call and @gvenzl.bsky.social) for keeping us covered — in every sense! 🙌

24.10.2025 09:04 👍 18 🔁 2 💬 1 📌 0
Post image

Who doesn't want to be part of the 16th edition of APEX World?
Showcase your expertise in APEX to the community! We are seeking presentations for all skill levels, from novices to seasoned professionals, and everything in between.

👉 Visit buff.ly/dJc3ogC to submit your abstract!

Open until Dec 1

22.10.2025 07:17 👍 6 🔁 5 💬 0 📌 0
Video thumbnail

There’s a new type of CSS scroll-state query coming: “scrolled”.

This one remembers the last direction you scrolled into, which you can use to build “hidey bars”: when scrolling down (or having scrolled down), the hidey bar hides itself. When then scrolling back up, the hidey bar reveals itself.

22.10.2025 16:48 👍 211 🔁 29 💬 14 📌 5
Post image Post image Post image

🇭🇷 First time on the island and what an amazing #HrOUG! 🌴✨

Great sessions, inspiring people, and an awesome community 🙌

Thanks to everyone who joined my talks and shared insights — can’t wait for the next one! 🚀

#orclAPEX

20.10.2025 07:10 👍 9 🔁 1 💬 0 📌 0
Preview
Thou shalt not wrap your connection pool, badly — #JoelKallmanDay Using oracledb.ConnectionPool is straightforward: first, you create the pool, and then you use the pool and connection object as a context manager. Like this: pool = oracledb.ConnectionPool(**param…

I thought I won't post anything for #JoelKallmanDay, but then I got sudden inspiration from the day job. TL;DR: if your Python code isn't thread safe, then even GIL might not save it.

priitp.wordpress.com/2025/10/15/t...

15.10.2025 17:11 👍 3 🔁 1 💬 0 📌 0

Uploading a file in Oracle APEX usually means submitting the page, which can be slow and annoying if you just want a preview.

In memory of Joel Kallman, here’s a simple client-side method to preview media files instantly.

#JoelKallmanDay #orclapex

👇
tm-apex.hashnode.dev/how-to-previ...

15.10.2025 15:43 👍 6 🔁 4 💬 0 📌 0
Preview
Why a Systems Assessment Can Make or Break Your ERP A smarter ERP starts with a clearer system landscape. You can’t modernize what you don’t understand.

To commemorate #JoelKallmanDay, I deep dive into the why and how of company-wide systems assessments. Because we can’t modernize what we don’t understand.  A smarter ERP starts with a clearer system landscape.
#JoelKallmanDay   #orclAPEX  #OracleERP

sandra-suarez.com/why-a-system...

15.10.2025 15:10 👍 8 🔁 3 💬 0 📌 0
Preview
DST diffs across the pond #JoelKallmanDay It's that time of the year. It's time to say goodbye to summer. It's time to set the clock and get back to normal time. ... It's also time f...

DST diffs across the pond

www.kibeha.dk/2025/10/dst-...

#JoelKallmanDay

15.10.2025 14:49 👍 8 🔁 3 💬 0 📌 0

#JoelKallmanDay

15.10.2025 14:09 👍 12 🔁 2 💬 0 📌 0
Post image

I have just posted a new blog discussing AI and AI for Oracle Security - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ukoug #ai #UKOUGDiscover25 #OracleCommunity #JoelKallmanDay #oracle #database #AI

15.10.2025 13:31 👍 7 🔁 4 💬 0 📌 0
Preview
Avatar image in Oracle APEX Using a REST Media Resource as an image source

A little help from me at the #JoelKallmanDay for everyone who ever struggled with adding an avatar image in their Oracle APEX apps.

Unfortunately, implementing such feature is not so straightforward, but here we go, see tutorial below 👇

#orclAPEX

blog.apexapplab.dev/avatar-image...

15.10.2025 11:21 👍 9 🔁 3 💬 0 📌 0
Post image Post image Post image

Our own Monty Latiolais joined the APEX Customer Success Stories panel at Oracle AI World 2025, sharing how organizations are transforming with Oracle APEX, Database, and OCI.

Stop by and see our team at Booth #10027

#OracleAIWorld #orclapex #OCI #OracleCloud #OracleAI

15.10.2025 18:53 👍 1 🔁 1 💬 0 📌 0
Preview
How am I supposed to log user audit of old/new values for Oracle APEX? #JoelKallmanDay

How am I supposed to log user audit of old/new values for Oracle APEX? 🤔📝🔍

#JoelKallmanDay #orclapex

mattmulvaney.hashnode.dev/how-am-i-sup...

15.10.2025 09:23 👍 9 🔁 2 💬 0 📌 0
UUIDs in Oracle Database UUIDs are useful, especially when you expose data in REST APIs, but there are cases where you may want to stick to the good old sequence-based primary key. UUIDs in Oracle Database #JoelKallmanDay UUI...

New blogpost enesi.no/2025/10/uuid... #JoelKallmanDay #oracle

15.10.2025 09:43 👍 4 🔁 4 💬 0 📌 0
Preview
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.

For #JoelKallmanDay I am sharing a free plug-in for reactive Markdown preview. It auto refreshes, supports tables, alerts, etc., and comes with three themes. #orclAPEX

hartenfeller.dev/blog/apex-re...

15.10.2025 05:03 👍 14 🔁 6 💬 1 📌 0
Preview
Fixing data faux pas with flashback table #JoelKallmanDay Triggered by traumatic DML errors ? Well, here's one flashback you won't mind having...

Fixing data faux pas with flashback table #JoelKallmanDay

Triggered by traumatic DML errors ? Well, here's one flashback you won't mind having...

15.10.2025 06:30 👍 4 🔁 1 💬 0 📌 0
Preview
Creating a Google XML Sitemap using Oracle APEX. #JoelKallmanDay Dynamically generate a Google XML Sitemap from an Oracle APEX application using PL/SQL and SQL/XML, ensuring your site is fully indexed by Google.

Today is #JoelKallmanDay, in memory of Joel Kallman, who inspired the entire #orclAPEX community.

As a tribute to Joel, I've written a blog post showing how to create a Google XML Sitemap using Oracle APEX.

blog.longacre.ch/2025/10/crea...

@oracleace.bsky.social @sym42.bsky.social

15.10.2025 06:56 👍 6 🔁 1 💬 0 📌 0
Post image

Thinking about community #JoelKallmanDay

oracle-base.com/blog/2025/10...

@oracleace @OracleAPEX #orclapex @OracleDatabase

15.10.2025 07:06 👍 5 🔁 1 💬 2 📌 0
Preview
Simplicity, Troubleshooting, #JoelKallmanday TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...

Apart from all the buzz around the "release" of 26ai, Today is also #joelkallmanday ,
Coordinated by @oraclebase.bsky.social, our community blogs in with that hashtag to remember Joel ...
pdvfirstblog.blogspot.com/2025/10/simp...

15.10.2025 07:19 👍 6 🔁 4 💬 0 📌 0

My 2025 contribution to #JoelKallmanDay

Apply Conditional Styling to Reports Using CSS only ✨

lmoreaux.hashnode.dev/oracle-apex-ap…

#orclAPEX

15.10.2025 08:06 👍 7 🔁 1 💬 0 📌 0
Creating APEX report with rolling set of columns #JoelKallmanDay The last several years I've participated in the Joel Kallman Day tributes with articles about SQL and PL/SQL. While there are no requirements for article topics, this year I wanted to contribute something within the framework Joel was best known for... APEX. Many reports aggregate data over time periods and will usually return different dates and times as distinct rows. In some reports though, it is more useful to show a rolling window of time.

Creating APEX report with rolling set of columns #JoelKallmanDay

The last several years I've participated in the Joel Kallman Day tributes with articles about SQL and PL/SQL. While there are no requirements for article topics, this year I wanted to contribute something within the framework Joel…

15.10.2025 04:01 👍 8 🔁 4 💬 0 📌 0

One more would have been too much 😅

15.10.2025 04:32 👍 1 🔁 0 💬 0 📌 0

This year, my contribution to the annual #JoelKallmanDay. Discussing developments in Agentic AI within the Oracle ecosystem, including the "newly" released Select AI Agent feature available in the Oracle Autonomous AI Database.

fuzziebrain.com/content/buil...

#oracle #aiagents #agenticai #orclapex

15.10.2025 03:26 👍 5 🔁 2 💬 1 📌 0
Preview
Is SYSDATE Deterministic? #JoelKallmanDay TL;DR No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement. Background On a customer site, we used faketime on the O...

Is SYSDATE Deterministic? #JoelKallmanDay

No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement.

www.salvis.com/blog/2025/10...

15.10.2025 01:59 👍 9 🔁 5 💬 0 📌 0

Security predicates exposed #JoelKallmanDay

connor-mcdonald.com/2025/10/15/s...

15.10.2025 00:17 👍 5 🔁 1 💬 0 📌 0
Preview
Fix Optimizer Estimate Issues from Implicit Conversions #JoelKallmanDay Learn how implicit RAW-to-VARCHAR2 conversions in Oracle break histograms, hurt optimizer estimates, and how to fix them safely.

New post for #JoelKallmanDay!
Ever wondered why the Oracle Optimizer sometimes ignores your histograms? Implicit data type conversions might be to blame. Here’s how to fix it without touching your SQL and with minimal schema impact.
#Oracledatabase

blog.sqlora.com/en/fix-optim...

14.10.2025 22:30 👍 8 🔁 1 💬 0 📌 0
Post image

The Oracle AI Database 26ai Free is available now🔥

I'm currently reading the release notes 🤓 And you?

#Oracle #AIWorld

14.10.2025 15:05 👍 4 🔁 0 💬 1 📌 0
Post image Post image

Thrilled to be speaking at #HrOUG2025 in Rovinj 🇭🇷!

💡 Fri 17 Oct – Workshop: Model a Business Process & Implement a Workflow App with Flows for APEX with @rallen2010.bsky.social

🧠 Sat 18 Oct – Why all APEX devs should learn more about HTML, CSS & web tech

See you there! #orclAPEX

10.10.2025 07:18 👍 4 🔁 0 💬 0 📌 0