Tag: PL/SQL

One year ago Steven Feuerstein launched a competition called “The Pl/SQL Challenge“. The idea was to let Oracle PL/SQL developers test their knowledge, learn and win prices by taking a daily quiz. The format seems to be a success: every day more than 1000 PL/SQL developers test their knowledge about the language, in total more […]

On friday my quiz was on the PL/SQL Challenge. Topic: “Guidelines for Designing Triggers: Avoid Non-Transactional Logic in DML Triggers” Yes, about “statement restart” My idea about the quiz was “making developers aware of the Oracle behaviour”. And I hope a lot of PL/SQL developers learned from it. It wasn’t easy to come up with […]

Steven Feuerstein started last year the PL/SQL Challenge, a quiz about…PL/SQL! What else could one expect from Steven😉 The PL/SQL Challenge is an interesting quiz to test your PL/SQL knowledge and win some great prizes(up to $1000!). Not only it’s about testing your knowledge, but also about learning a lot PL/SQL(even experienced developers can learn!). […]

In my previous post I mentioned the problem with compiling a program unit that calls a database function with result cache. Like I wrote in that post, the problem exists in the PL/SQL Client version. There’s a patch available to update the PL/SQL client: Oracle Database Server Version 11.1.0.7 Patch 33. This is a database […]