Herbert Riess

12 Flips | 3 Magazines | @HerbertRiess | Keep up with Herbert Riess on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Herbert Riess”

What Would Grexit Look Like?

Once a theoretical fear of euro-pessimists, Grexit—a Greek exit from the eurozone—may be soon upon us. The euro was designed to be an irrevocable currency; there is no procedure in its rules or treaties for a country to stop using it. So precisely what would happen is highly speculative. But let’s …

Dow Jones

ORA-12838

If you do an <i>INSERT /* APPEND */</i>, you cannot query the table afterwards until you have done a <i>COMMIT</i>. If you try to do so, Oracle gives you an …

A function gets called twice if the result_cache is used

Recently I showed simple example how result_cache works with non-deterministic functions and observed strange behaviour: a function gets fired once …

SQL vs. PL/SQL

Which piece of code will be faster (clue – the table in question has no indexes):Option 1 – pure SQLOption 2 – a silly PL/SQL row by row …

Auditing Enhancements (Audit Policies and Unified Audit Trail) in Oracle Database 12c

A little over a year ago I was at the BGOUG Spring Conference and I watched a session by Maja Veselica about auditing in Oracle Database 12c. At the …

Best UTL_FILE Practice

In a post a couple days ago, I promised to provide a best practice approach to reading external files with the UTL_FILE package. My first assumption …

Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script!

I have also done major updates to Snapper logo which you should check out. If you have ever looked into the Snapper source code you know the old logo …

Outputting your data using inbuilt SQL Dev formatting

Oracle has build a number of formatting options into SQL Developer to allow you to output your data in some standard formats. This removes the need …

Comment on NVL() by Coalesce v. NVL | Oracle Scratchpad

[…] nvl() function (in many cases) there are significant differences in behaviour, some that suggest it’s a good idea to use the substitution and …

Changing Default Item Required Error Message in APEX

In APEX, if a page item is a required value it is no longer necessary to create an explicit validation. Setting the item's option "Value Required" to …