One of Java’s big strengths, in my opinion, is the fact that most naming conventions have been established by the creators of the language. For example: If someone does not adhere to these conventions, the resulting code quickly looks non-idiomatic. What about SQL? Many do not agree on the “correct” case: There seems to be … Continue reading A Guide…
#pl sql
5 posts
29 Oct 2019
7 Sept 2018
I recently stumbled upon a curious query on a customer’s productive Oracle database: Two things caught my attention: The query was executed many billions of times per month, accounting for about 0.3% of that system’s load. That’s 0.3% for something extremely silly! I don’t think that customer would ever qualify the DUAL table as SYS.DUAL, … Continue reading Beware of…
8 Nov 2016
Some of the biggest limitations when working with Oracle PL/SQL from Java is the lack of support for a variety of PL/SQL features through the JDBC interface. This lack of support is actually not limited to JDBC, but also extends to Oracle SQL. For instance, if you’re using the useful PL/SQL BOOLEAN type as such: … Continue reading Use jOOQ…
8 Aug 2016
I’ve recently made an embarassing discovery: wha. I've never used while loops in PL/SQL. TIL :) — Lukas Eder (@lukaseder) July 26, 2016 Yes. In all of my professional work with PL/SQL (and that has been quite a bit, in the banking industry), I have never really used a WHILE loop – at least not … Continue reading Why I…
13 Apr 2015
Syntax is one of those topics. One of those emotional topics that lead to very very very important discussions. I personally like PL/SQL. It is extremely verbose, and precise. It forces you to adhere to a very strong and rigid type system, slowing you down, which is likely to help you avoid mistakes. There is … Continue reading It’s the…