Blog: Stewart Ashton

208 blogs updated: 6 min. ago
More on Optimistic Locking with ORA_ROWSCN
Thanks to comments by Tony Hasler and pingbacks from Jeff Kemp, here's more detail on how optimistic locking works with SCNs, especially wit...
22-06-2017 11:32:16 Stewart Ashton Oracle
Optimistic Locking: One SCN to rule them all
Previously I showed how to avoid lost updates with ORA_ROWSCN. Now let's create an API that avoids lost updates with just one SCN. What kind...
21-06-2017 16:51:10 Stewart Ashton Oracle
Avoiding Lost Updates with ORA_ROWSCN
Applications today use "optimistic locking" to avoid lost updates. Tom Kyte thought of using ORA_ROWSCN for optimistic locking, then decided...
17-06-2017 12:08:45 Stewart Ashton Oracle
Comparing Expression Lists (not tuples)
This post is a long-winded answer to a question Bryn Llewellyn asked me on Twitter about comparing expression lists.
08-05-2017 18:26:31 Stewart Ashton Oracle
#OUGN17 Row Pattern Matching with MATCH_RECOGNIZE
OUGN17 (the boat conference) rocked - and the boat didn't, thank goodness. I gave two talks about row pattern matching that were well receiv...
12-03-2017 09:43:36 Stewart Ashton Oracle
Multi-Table Inserts with Sequences
Multi-table inserts are a drag when sequences are involved, because we don't have enough control over when the sequence is incremented. I've...
08-01-2017 16:40:19 Stewart Ashton Oracle
Disappearing Data
Did you know that Oracle DML can silently change data you want to put into the database? A recent twitter discussion started by Martin Widla...
06-01-2017 14:47:17 Stewart Ashton Oracle
#UKOUG_Tech16: Advanced Row Pattern Matching
I presented this topic on Super Sunday. The latest version is now on the Tech16 site and on
11-12-2016 08:06:36 Stewart Ashton Oracle
#UKOUG_Tech16: Ranges, Ranges Everywhere
I presented this topic on at Tech 16 on Monday afternoon. The latest version is on the Tech 16 website and on Thanks to the organisers, staf...
11-12-2016 01:30:35 Stewart Ashton Oracle
#DOAG2016: Bug !
I did it: in my proudest moment at DOAG2016, at the very end of my second presentation, I presented a brilliant SQL query with a bug in it. ...
20-11-2016 09:55: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.