Herbert Riess

12 Added | 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?

How would Grexit arrive?<p>Through the banks. There is no political or legal procedure for “ejecting” Greece from the euro, and Greece’s government has repeatedly said it doesn’t want to voluntarily withdraw. That suggests an exit would come if the state of the banks is so bad that there is no other …

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 …

Databases

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 …

Databases

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 …

Databases

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!

Snapper V4 Webinar<p>Snapper V4 is out!<p>The major new features include:<p>RAC support – ability to query stats from remote instances<br>• Manual Before and After …

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 …

NVL()

Here’s a point that’s probably fairly well-known, but worth repeating – <i>nvl()</i> and <i>coalesce()</i> aren’t identical in behaviour but you may have some cases …