Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺

@kibeha.dk

582 Followers 238 Following

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

Freefall comic. Transcript:

Sam: Telling the computer what I want to have done. It makes my job easy. I don't know how it works. I don't know what I'm actually doing.
Sam: I've always assumed the other guys know what they're doing. If they're using A.I. as well... this could be a problem.
Sam: It makes it too obvious that almost nobody knows what they're actually doing. That destroys one of the illusions societies are built on.

DBAndyCapp and myself at the registration desk of MakeIT 2026 conference

create assertion Notes_RefRecId_MultiFK check (
not exists (
select null
from Notes n
where not exists (
select null
from DebTab d
where n.RefFileId = 11
and d.RecId = n.RefRecId
) and not exists (
select null
from CreTab c
where n.RefFileId = 15
and c.RecId = n.RefRecId
) and not exists (
select null
from StoTab s
where n.RefFileId = 27
and s.RecId = n.RefRecId
)
)
);

create assertion Notes_RefRecId_MultiFK check (
all (
select n.RefFileId, n.RefRecId
from Notes n
) nref
satisfy (
exists (
select null
from DebTab d
where nref.RefFileId = 11
and d.RecId = nref.RefRecId
UNION ALL
select null
from CreTab c
where nref.RefFileId = 15
and c.RecId = nref.RefRecId
UNION ALL
select null
from StoTab s
where nref.RefFileId = 27
and s.RecId = nref.RefRecId
)
)
);

Banner showing I'm a Speaker at APEX Connect May 18-20 2026 at Heide Park Soltau