Stew Ashton

There's a small gotcha (maybe you mentioned it and I missed it?) : json_object(*) doesn't capture invisible columns.

In the same row, I suppose the start date must be earlier than the end date? I don't see where that is enforced...

Please don't forget "compliment" and "complement"...

The only applications I have truly been happy to have written are those where I had strong contacts with the users and they could tell me what they really needed. Feel trumps look!

It’s the barometric pressure I was told…

Have you definitively left the conference circuit? It's been a few years for me, but I sometimes wish I could go one more time to see again so many people I have fond memories of. Do you have any future conference plans or possibilities?

Trying to remember if you ever asked me about anything and trying not to feel bad if you didn't...

I thought of a requirement to simply reverse the items in a JSON array, and then discovered that REVERSE was added to JSON_TRANSFORM (in 26ai I think). JSON is improving continuosly and more rapidly than any tech I know of in the Oracle database. 👏👏👏

Did you pass by the Abbey of Fontgombault ? I spent 5 years there in the ‘70s.

Come on, that's *one-third off* ! (on the 9s 🫠 )

Yes! The 10x net positive is immediately obvious, sorry if I gave another impression.

People who know me better would not even let me *pretend* to be a dba 😱
Both things I mentioned are allowed in LiveSQL, so I assumed growing pains, not a conscious decision. I'll save this kind of thing for the forums henceforth.

Yet more remarkable work from you and your teammates! It would be nice, though, to have info on limitations (even if temporary). For example, is it just me or is there no way to see parameters other than NLS? And of course no access to V$SESSION so no execution plans 🤷‍♂️
Still great work though 👏

Truly a very high-VALUE post!

I’m waiting a bit longer to get more protection later on for the flu. As for Covid, it’s too close to my last jab right now. No SpongeBob for me 😢

From experience, this is a time of intense activity, fatigue and disorganised reflexion. May your parent rest in peace and may you benefit from all possible support and internal strength 🙏🏻

Where I buy my wine, every bottle of beaujolais is "neuve". If you are buying used beaujolais that's your choice, but it's an unusual one...

Nouveau means just created or a new replacement. Neuf means unused or at least “like new”.

Joel Kallman Day 2025 : Announcement

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

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

See the banner of my blog : stewashton.wordpress.com
On the way back to Sorento from Capri in January. Also living in France but not where you are 🤷‍♂️

YES to sentences 1 and 3. APEX apps can be "low code", I too did some COVID apps quickly in 2021. Still, many APEX apps are "low code" on the front end but less so on the back end.
What's sad is that so many developers want the opposite: "low code" to the DB and code the heck out of everything else.

APEX may be "low code" for some, but I see it more as a window to the world for database developers and DBAs. Not really the same thing, in fact one might say "low code" denigrates database development. 2/x

I wrote APEX applications for the Paris medical school. Adding DDL, backend code and PL/SQL or SQL embedded in the apps, I am up to almost 8000 lines of code. When we say "low code" it really means "little or no javascript". My son runs a Web dev company and they won't touch my stuff for money. 1/

If only bikes were equal users and not privileged users! After 37 years in Paris, the only accident in my family was last year when my daughter had her arm broken by a bike collision. No way to hold the cyclist responsible because rules of the road are not precise.

Many in the US think that people are the problem, not the guns. But they’re OK with giving the problem easy access to guns… 🤦‍♂️ #GunControlNow #USA #USALogic

I'm not sure how "obvious" it is. Aside from all the physical, logical, legal and contractual separations, the customer can manage the encryption keys so even if the data was surrendered the feds would have to break the encryption.
As the article states, EU-based tech may have issues too.

Some software does work like that; it’s just that everybody badmouths it. Think mainframes or SQL.

If your without_merge procedure did the UPDATE first, wouldn't it behave like MERGE?

In the MERGE statement, you want a "restart" when the insert fails? The whole statement would have to be rolled back and retried. With UPDATE restart, rows are selected and locked so the restart will always succeed. In a MERGE restart, success would not be guaranteed; how many restarts do you want?

Wasn't it a COVID app?