Tim Hall

Tim Hall

@oraclebase.bsky.social

A DBA/Developer who has a website.

1K followers103 following410 posts

Tim Hall reposted

Philipp Hartenfeller
@hartenfeller.dev

Oracle Deep Data Security is so good; a brilliantly designed relational database enhancement. But there is a big catch: it currently requires a Cloud Identity Provider, also for #orclAPEX ... #JoelKallmanDay #Oracle #SQL hartenfeller.dev/blog/deep-da...

hartenfeller.devDeep Data Security is here to stay #JoelKallmanDayI think Deep Data Security (DDS) is one of the most promising additions to Oracle 26ai. The idea is straightforward: describe who may read or change which data with SQL, and let the database enforce i...

Tim Hall reposted

Oana Bonu
@oanabonu.bsky.social

After years of working with the #OracleACE community, the names have become faces, friendships & stories. For my first #JoelKallmanDay, I wrote about the people behind the technology and what community really means to me. oanapadurarubonu.medium.com/sometimes-i-...

oanapadurarubonu.medium.comSometimes I Forget I’m Not One of Them #JoelKallmanDayBefore joining Oracle, I had no idea a community like this could exist. Of course, I knew what communities were. I had — and still have —…

Tim Hall reposted

Dani Schnider
@danischnider.bsky.social

My contribution to #JoelKallmanDay: A new blog post about how to find and avoid duplicates in data integration (examples with fictitious data, inspired by a true story) danischnider.wordpress.com/2026/10/13/h...

danischnider.wordpress.comHow to Find and Avoid Duplicates in Data Integration #JoelKallmanDayDuplicate rows are the enemy of every data integration developer. They can cause job failures and – even worse – wrong results. Somtimes it is more complex than expected to avoid them. …

Tim Hall reposted

Sean D. Stuber
@sdstuber.bsky.social

Looking at Proxy Users #JoelKallmanDay I had a few questions come up lately that involved proxy users and some of the answers were surprising. To illustrate the scenarios I'll create a couple of users, one with a password, one without, and a user that will proxy into each of them. I'll also grant…

seanstuber.comLooking at Proxy Users #JoelKallmanDayI had a few questions come up lately that involved proxy users and some of the answers were surprising. To illustrate the scenarios I'll create a couple of users, one with a password, one without, and a user that will proxy into each of them. I'll also grant the users privileges to look at some of the data dictionary to see how their activity is tracked.

Tim Hall reposted

Andrej Pashchenko
@andrejsql.bsky.social

#JoelKallmanDay #Oracle26ai introduces QUALIFY — a welcome addition to Oracle SQL that makes filtering on analytic function results much easier. But what happens under the hood? Query transformations and execution plans reveal a few surprises. blog.sqlora.com/en/oracle-26...

blog.sqlora.comOracle 26ai: QUALIFY Under the Hood #JoelKallmanDayOracle 26ai introduces QUALIFY. Explore how it works, how Oracle transforms it internally, and why the generated SQL can produce a different execution plan.

Tim Hall reposted

Mike Smithers
@antikyte.bsky.social

Sawn-off by SQL*Plus – how to prevent it rounding long numeric values #JoelKallmanDay Whenever I need to generate a CSV in a batch routine, I turn to good old SQL*Plus. However, when testing such a routine recently, I came across a behavioural quirk which left me a bit stumped. Hopefully, what…

mikesmithers.wordpress.comSawn-off by SQL*Plus – how to prevent it rounding long numeric values #JoelKallmanDayWhenever I need to generate a CSV in a batch routine, I turn to good old SQL*Plus. However, when testing such a routine recently, I came across a behavioural quirk which left me a bit stumped. Hopefully, what follows will help others avoid falling down the rabbit hole I found myself in when trying to figure out just what was happening...

Tim Hall reposted

Piet de Visser
@pdevisser.bsky.social

For #JoelKallmanday I want to publish my ideas on "Doing Demos". simpleoracledba.blogspot.com/2026/10/got-... With a tip of the hat to Tim from @oraclebase.bsky.social for keeping the tradition alive. I did consider calling it How2Demo, but that catchphrase is already taken... ;-)

simpleoracledba.blogspot.comGot a Good Idea? Show it with SQL #JoelKallmandayTL;DR: Always use a SQL-script too demonstrate what you to do. And make it Repeatable, and preferable Self-explaining. That way, anyone can ...

Tim Hall reposted

Erik van Roon
@evrocs.bsky.social

Better get your post ready....

Tim Hall@oraclebase.bsky.social

Joel Kallman Day 2026 : Announcement oracle-base.com/blog/2026/09... #JoelKallmanDay @oracleace @OracleDevs @OracleDatabase @OracleREST @OracleAPEX #orclapex

Tim Hall
@oraclebase.bsky.social

Note for non-UK folks. The UK is extremely hot at the moment, so most people I know are not sleeping well. Expect us to be more miserable than usual. You have been warned. 😀