Blog: Stewart Ashton


213 blogs updated: 30 min. ago
Ranges with NULLs 07: Swiss Army Knife
I came up with this name a few years ago for a problem that I couldn't solve then: analyse a series of ranges and say whether and how they o...
0
06-12-2018 10:44:31 Stewart Ashton Oracle
Ranges with NULLs 06: Overlaps with Conflicting Data
In 2014 I attacked the problem of "Overlapping ranges with priorities". This time I'll deal with NULLs and propose an improved solution.
0
03-12-2018 07:41:10 Stewart Ashton Oracle
Ranges with NULLs 05: Segments
Take two overlapping ranges: "1 to 3" and "2 to 4". We can divide them into three smaller ranges: "1 to 2", "2 to 3" and "3 to 4". I'll call...
0
26-11-2018 07:18:25 Stewart Ashton Oracle
#DOAG2018: my presentations
I had a great time at DOAG 2018, both during the conference and in the evenings. Thanks to everyone who participated in my two sessions: it ...
0
23-11-2018 17:59:38 Stewart Ashton Oracle
Ranges with NULLs 04: Pack, Merge
In this post, I'm going to treat two closely related but distinct requirements: "Pack": in a SELECT, return contiguous or overlapping ranges...
0
12-11-2018 18:26:42 Stewart Ashton Oracle
Ranges with NULLs 03: Gaps
When I wrote "Gaps in Date Ranges: when are you free?", I handled NULLs using "magic" values. This time I'll try not to cheat.
0
29-10-2018 08:07:50 Stewart Ashton Oracle
Ranges with NULLs 2: test cases
When I write SQL there is a bit of trial and error (laughter), so I need as complete a set of test cases as possible. Here's what I came up ...
0
22-10-2018 12:35:39 Stewart Ashton Oracle
Ranges with NULLs 1: starting over
I have written a lot about ranges, mostly based on dates, and I have tried my best to avoid NULLs in "from" and "to" columns. I give up: NUL...
0
16-10-2018 15:52:34 Stewart Ashton Oracle
Optimistic Locking 9: proof of concept
To wind up this series about optimistic locking using the SCN, here is a sample API for querying and updating the DEPT table, using JSON as ...
0
03-08-2018 13:42:05 Stewart Ashton Oracle
Optimistic Locking 8: double-checking with flashback
Some optimistic locking methods, including the SCN method, can detect intervening updates even when column values have not really changed. W...
0
23-07-2018 08:18:27 Stewart Ashton Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.