This is an update on the previous article “Strange behavior with EBR“.To try to understand a little more I have tested some more. The result suggest that what’s inherited in my latest edition is actually not what I first thought (read last article). Let’s have a look.
I got some strange behavior with the Edition Based Redefinition feature this other day. I have 4 editions (RELEASE_1, RELEASE_2, RELEASE_3 and RELEASE_4). I create a package FOO with one procedure P1 in RELEASE_1. Then i recreate the package in RELEASE_2 adding a second procedure P2. Now I expect RELEASE_3 (and RELEASE_4) to have inherited […]
¶
Posted 27 July 2024
§
Oracle
‡
°
In my last blogpost (“Strange behavior in MERGE with sequence NEXTVAL”) I had a link to article written by Bob Jankovsky. In this article is suggest solving the issue with MERGE and nextvalue by returning the nextvalue from a function. In this blogpost I’ll do some tests and see how this behaves (regarding timings).
¶
Posted 21 December 2023
§
Oracle
‡
°
Today we learned the following: “When using a sequence in a MERGE statement, the nextvalue is generated for all rows both updated and inserted (hence all rows in the source).” Our initial reaction was that this must be a bug, but is it really?
Tanel Poder have uploaded his TPT script to GitHub. If you have never looked as his script I highly recommend spending some time on them. You’ll find them at: https://github.com/tanelpoder/tpt-oracle
¶
Posted 28 June 2018
§
Oracle
‡
°
SQL Daily just tweeted about the fact that JDBC roundtrips are expensive. This is something many developers either forget or do not know. I have seen so many chatty applications killing the application performance, and the database performance. Toon Koppelaars have performed some excellent presentations showing this. Lukas Eder have also written some nice articles […]
I really enjoyed the following article about Java, Time and Dates: https://yawk.at/java.time/ From the article: An introduction to java.time Time is a complex topic. Many programmers are unfamiliar with the difficulties and common bugs associated with time. This has in the past lead to time APIs that allowed “sloppy” code which can lead to bugs in […]
¶
Posted 28 April 2018
§
Java
‡
°
The developers in one of the teams I work within wanted to export the tables in a schema with limited number of rows. This could of course be done by running expdp command line. But this time we needed to find the last x numbers of primary keys in one of the central tables and […]
