Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
banner
kibeha.dk
Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
@kibeha.dk
550 followers 240 following 360 posts
Danish geek πŸ€“ Oracle SQL & PL/SQL Developer β™  ACE Director 4️⃣2️⃣ #SYM42 πŸ‘¨β€πŸ³ Likes to cook πŸš€ Reads sci-fi 🍺 Beer Enthusiast 🏒 Cegal Danmark A/S πŸ§‘β€πŸ’» https://kibeha.dk
Posts Media Videos Starter Packs
Pinned
You want to read the book?

www.apress.com/gp/book/9781...
www.amazon.com/Practical-Or...

You want to taste the beer?

Be at #POUG2025 poug.org/en/edycja/po...

Lucky you if you have a ticket - it's sold out.
Be faster next year!

( @pougorg.bsky.social organizes awesome conferences 🍻😁)
Some of the first batch of Monks and Nuns (the first beer in the Practical Oracle Beer series - www.kibeha.dk/p/practical-... ) is canned and ready to travel to #POUG2025 🍺
"So the AI makes the perfectly logical decision, to make shit up!"

Well, this quote is from a comic strip set in the future and dealing with self-aware AI, but somehow it feels relevant to present day too πŸ˜‡

( Source: www.poisonedminds.com/d/20251024.h... )
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
Automation: Perfection is the enemy of good

oracle-base.com/blog/2025/10...
Unboxing #OracleACE swag is early Christmas 😍.

Thank you, @oracleace.bsky.social .
Those umbrellas will come in handy.

(I suppose that makes @gvenzl.bsky.social Santa πŸŽ…πŸ˜)
What's worse is, we have world leaders & governments who are acting like this. And the rest of the kids in the playground say it's not nice and they should not do it, but cower if the bully looks at them.
Rather than, I don't know, ganging up & dragging the bully behind the bike sheds for a lesson.
In other words, apply a bit of common sense πŸ‘πŸ˜
Okay, so dropping created columns can happen either way.

But forward fix you just don't rollback everything and try again with a fixed version, instead you fix only what's necessary to be fixed.
Okay, but then if a forward fix also does things like:

ALTER TABLE CUSTOMERS DROP COLUMN EMAIL;

Then it has the same downsides as rollback scripts, right?
GRAPH_TABLE: operator.
JSON_TABLE: function.
XML_TABLE: function.
Use all 3 in FROM like a table function.

UUID: operator.
JSON_ID: function.
SYS_GUID: function.
Call all 3 like a function.

I get operators like +, ||, COLLATE or PRIOR.

But "function-like" operators vs. functions? What's the diff?
Not sure I completely get it.

What's the difference between "a new migration that undoes..." versus the rollback scripts in strategy 1?

The word "undoes" in strategy 3 must have a different meaning?

Is strategy 3 like "if it fails, do *not* go back, but apply a hotfix that fixes the error"?
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
πŸ‡­πŸ‡· 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
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
Goodbye Sveti Andrija πŸ‘‹

The anniversary #HrOUG2025 was a blast - now it’s time for @kibeha.dk and me to head homewards.

Thank you Davor, David and the entire HrOUG team for some great days. Hopefully we’ll see each other next year.
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
A funny last session at #HrOUG2025 with SELECT AI Funhouse and @kibeha.dk
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
Tennis before the first session on day 3 of HrOUG with team β€žAwesomeβ€œ and β€žOMGβ€œ. It was great fun. Thanks! #HrOUG25 #HrOUG2025
Small font screenshots on your slides are bad when the projector isn’t great, but if you need it, then at least don’t use dark mode - it makes it even more unreadable.
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
β€œWell, wellβ€”another blonde hair. … Conducting a little more β€˜research’ with that Jane Goodall tramp?”
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
Having fun at the tennis court #hroug25
#OracleACE early morning tennis at #HrOUG2025 …

… some people have too much energy πŸ™„πŸ˜‡
Awesome list of posts 🀩

#JoelKallmanDay
Joel Kallman Day 2025 : It’s a Wrap! (#JoelKallmanDay)

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

@oracleace @OracleAPEX #orclapex @OracleDatabase
As predicted, too late for the 15:30 boat.

No problem, that leaves time for obligatory boat-waiting-beer before 16:30 🍺

#HrOUG2025
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
Couple days in Zadar to relax before #HrOUG2025
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
Are you passionate about Oracle tech, eager to grow your career, or looking to join a dynamic community of innovators? Then ConTech by RoOUG 2025 is the event you can’t afford to miss next month in Bucharest!
medium.com/@oanapadurar...
Discover the Oracle ACE Effect at ConTech 2025: Join Us in Bucharest!
3–4 November 2025 | Politehnica University Conference Center, Bucharest
medium.com
Reposted by Kim Berg Hansen: SQL β™  πŸ€“ πŸ‘¨β€πŸ³ 🍺
Did you already sign up for the autumn event of the Nederlandse Oracle User Group (nlOUG)? It is going to be a great day with an awesome - international - speaker line-up! 🌍

Don't miss outβ€”spots are filling up fast! Head over to nloug.nl/events/najaa... and secure your place today.
Database Cloud & Developer Dag 2025 | Oracle User Group
nloug.nl