Oracle Blog - Oracle - Toad World

Oracle Community

Oracle Blog

Porus Homi Havewala
Follow /19 Jan 2017 at 4:49am / Oracle Blog

What is Basic Flashback Data Archive?

This is an interesting tidbit. The Database Licensing Guide here makes the following statement: “ Basic Flashback Data Archive is in all editions. Optimization for Flashback Data Archive requires EE and the Advanced Compression option.”...
61 0 /
Steven Feuerstein
Follow /18 Jan 2017 at 11:00pm / Oracle Blog

Players for PL/SQL Challenge Championship for 2016

The following players will be invited to participate in the PL/SQL Challenge Championship for 2016, currently scheduled to take place on 23 March at 14:00 UTC. The number in parentheses after their names are the number of championships in which they have...
65 0 /
Steven Feuerstein
Follow /18 Jan 2017 at 12:57pm / Oracle Blog

Emulating a finally clause in PL/SQL

PL/SQL does not support a finally clause, as many other languages do, including Java. Here's a description of the finally block from the Java SE doc: The finally block always executes when the try block exits. This ensures that the finally block is...
68 0 /
Michael McLaughlin
Follow /18 Jan 2017 at 1:22am / Oracle Blog

Tips & Techniques - PL/SQL Object Table Function

This article covers how to write PL/SQL object table functions. PL/SQL object table functions provide you with a powerful technique to solve complex query problems. You can use object table functions to return result sets that you can’t write as...
107 0 /
Deepak Vohra
Follow /17 Jan 2017 at 8:26pm / Oracle Blog

DevOps for Docker - A Trend for 2017

Docker container has revolutionized the use of software with its modularity, platform independence, efficient use of resources, and fast installation time. Docker lends itself to the DevOps approach to software development. This article looks at the technology...
58 0 /