Author | Lightnews

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

kibeha.dk

Posts Media Videos Starter Packs

Pinned

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · Aug 28

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 🍻😁)

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · Aug 28

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 🍺

A book titled "Practical Oracle SQL" in front of stacked cans of a beer called "Monks and Nuns"

2 5

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 23h

"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 ♠ 🤓 👨‍🍳 🍺

Tim Hall @oraclebase.bsky.social · 23h

Automation: Perfection is the enemy of good

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

2 7

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

Umbrellas are a necessity ☔️

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

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 🎅😁)

3 1 6

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

#SayNoToBullies

Martin Widlake @martinwidlake.bsky.social · 1d

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.

Calvin and Hobbes @calvin-and-hobbes.bsky.social · 2d

Everyone knew that one kid…🙄
#CalvinandHobbes #PlaygroundDrama

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

In other words, apply a bit of common sense 👍😁

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

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.

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

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?

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

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?

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 1d

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 ♠ 🤓 👨‍🍳 🍺

Louis Moreaux @moreaux-louis.bsky.social · 4d

🇭🇷 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

1 8

Reposted by Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

DB Andy Capp @dbandycapp.bsky.social · 5d

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.

1 3

Reposted by Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

Dani Schnider @danischnider.bsky.social · 6d

A funny last session at #HrOUG2025 with SELECT AI Funhouse and @kibeha.dk

1 5

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 7d

It was fast ⏩😁

Reposted by Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

Philipp Salvisberg @salvis.com · 7d

Tennis before the first session on day 3 of HrOUG with team „Awesome“ and „OMG“. It was great fun. Thanks! #HrOUG25 #HrOUG2025

2 5

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 7d

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 ♠ 🤓 👨‍🍳 🍺

THE FAR SIDE DAILY @bot.cowtools.org · 8d

“Well, well—another blonde hair. … Conducting a little more ‘research’ with that Jane Goodall tramp?”

1 21 200

Reposted by Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

Philipp Salvisberg @salvis.com · 8d

Having fun at the tennis court #hroug25

1 1 4

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 9d

#OracleACE early morning tennis at #HrOUG2025 …

… some people have too much energy 🙄😇

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 9d

Awesome list of posts 🤩

#JoelKallmanDay

Tim Hall @oraclebase.bsky.social · 9d

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

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

@oracleace @OracleAPEX #orclapex @OracleDatabase

1 3

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 9d

DST diffs across the pond

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

#JoelKallmanDay

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...

www.kibeha.dk

3 8

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 9d

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 ♠ 🤓 👨‍🍳 🍺

DB Andy Capp @dbandycapp.bsky.social · 10d

Couple days in Zadar to relax before #HrOUG2025

1 3

Reposted by Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

Oana Bonu @oanabonu.bsky.social · 11d

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

2 4

Reposted by Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

Roel @apexconsulting.nl · 11d

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

3 4