Lightnews — Scholar-powered news

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

@kibeha.dk

550 followers 240 following 350 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

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

DB Andy Capp @dbandycapp.bsky.social · 13h

Couple days in Zadar to relax before #HrOUG2025

1 2

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

Oana Bonu @oanabonu.bsky.social · 14h

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

1 2

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

Roel @apexconsulting.nl · 1d

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 3

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

Martin Widlake @martinwidlake.bsky.social · 1d

A 4-word horror story specific to the Oracle world:

"Burleson taught me this"

Marjorie James Keenan @unenthusiast.com · 2d

In honour of spooky month, share a 4 word horror story that only someone in your profession would understand.

rm -rf ~/

hammancheez @hammancheez.bsky.social · 2d

"The chancellor approved it"

3 1 12

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

a cartoon of scooby doo riding a dog with the words that 's scary below him .

ALT: a cartoon of scooby doo riding a dog with the words that 's scary below him .

media.tenor.com

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

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

Heading to #HrOUG2025 with @kibeha.dk

Looking forward to the 30 year anniversary 🤩

1 5

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

a baby is sitting on a bed wearing a varsity shirt and crying .

ALT: a baby is sitting on a bed wearing a varsity shirt and crying .

media.tenor.com

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

Will you look at that😮- It takes *two* slides to show all the ACEs speaking at #HrOUG2025🤩

It's going to be just awesome‼️

1 2

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

SQLDaily @sqldaily.bsky.social · 6d

Are you making any of these common #SQL mistakes?

Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions

@lukaseder.bsky.social explains what to do instead & lists 7 more

10 Common Mistakes Java Developers Make when Writing SQL

This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java develop…

buff.ly

4 7

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

Tim Hall @oraclebase.bsky.social · 6d

Don't forget about #JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

Tim Hall @oraclebase.bsky.social · 20d

Joel Kallman Day 2025 : Announcement

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

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

2 2

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

oracleugs.bsky.social @oracleugs.bsky.social · 7d

📢 Oracle AI World attendees, make sure to visit our Oracle User Groups booth in the AI Hub.

🚶‍♂️‍➡️ Come by and say Hi!
👨‍🏫 Learn what User Groups are all about
💡 Walk away knowing more about what's in it for you

2 2

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

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

KEEP is very useful 👍

If you are one of those that didn’t know about it, look in the #SQL reference manual under FIRST and LAST.

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

Yes!

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

Chris Saxon @chrisrsaxon.bsky.social · 8d

Congrats to the Oracle Dev Gym Weekly DB winners for Sept 2025:

1st Stelios Vlasopoulos
2nd Andrey Zaytsev
3rd mentzel.iudith

🍾🏆👏

This dedicated trio are also the top-3 ranked players for Q3 2025

See the full rankings at devgym.oracle.com/pls/apex/f?p...

devgym.oracle.com

1 1

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

When I last presented "Invitation to the Wedding of JSON and Relational Data" we were at version 23.4. Now to update it a "little" bit for version 23.9...

Oh...

There were new JSON features in:

- 23.5
- 23.6
- 23.7
- 23.8
- 23.9

Stop, Oracle, Stop! It'll be impossible to finish in 45 minutes!

a man is sitting at a desk talking on a phone while a woman holds a piece of paper over his head

ALT: a man is sitting at a desk talking on a phone while a woman holds a piece of paper over his head

media.tenor.com

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

Niall Mc Phillips @niallmcp.bsky.social · 11d

I'll be speaking at the 30th edition of the fantastic HrOUG conference in Rovinj, Croatia! 15th-18th October.

A great conference that attracts speakers and participants from all over the world.

2025.hroug.hr/eng/

#HrOUG2025 #HrOUG30
@oracleace.bsky.social @sym42.bsky.social

1 4

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

Erik van Roon @evrocs.bsky.social · 11d

Two weeks from today I'll be talkinig about SQL Macros at #HrOUG2025 in Rovinj, Croatia.
That alone should be enough to attend 😁
But apart from that there are loads of other speakers and since it's the 30th (!!!) time, I expect a lot of celebration as well.
There may still be time to get a ticket!

1 1 4

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

Got mine written and scheduled.
How about you?
#JoelKallmanDay

Tim Hall @oraclebase.bsky.social · 12d

Don't forget to start writing your post over the weekend. #JoelKallmanDay

Tim Hall @oraclebase.bsky.social · 20d

Joel Kallman Day 2025 : Announcement

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

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

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

a black and white photo of a cat wearing a top hat that says " you 're welcome "

ALT: a black and white photo of a cat wearing a top hat that says " you 're welcome "

media.tenor.com

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

Football pitch size is indeterminate:

www.harrodsport.com/advice-and-g...

But okay, if the news item had stated 600 "Standard Premier League" football pitches, then 105x68 would be right 😇

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

a crowd of people at a concert with their hands in the air in front of a large screen with a skull on it

ALT: a crowd of people at a concert with their hands in the air in front of a large screen with a skull on it

media.tenor.com

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

Samuel Nitsche (he/him) @developer-sam.bsky.social · 13d

Little sneak peek of my practicing efforts...

#DontGoBreakingMyCode
#MusicalKeynote

1 1 2

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

Nice 👍.

If you can't get to files on the db server, in VS Code you can:

select apex_barcode.get_qrcode_png(p_value=>'https://kibeha.dk',p_scale=>2) as qr_blob from dual;

Right-click (BLOB) output, pick Single Record View.
Click the three dots.
Click Download button.

That gets the PNG clientside.

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

Martin Bach @martindba.bsky.social · 13d

🔧 Life Hack: you don’t need an external service to generate QR-codes. APEX can do this for you 🤯

In this article I share how I created a QR-code in PL/SQL for use in an upcoming presentation 🖥️ APEX is so much more than a low code platform 🤩

🔗 martincarstenbach.com/2025/10/01/l...

Life hack: encode a URL in a QR code using APEX

Someone in the community once said to me that APEX is awesome even if you’re not writing APEX apps in the database. It comes with so many useful featues – like the one you’re read…

martincarstenbach.com

1 3 5