Tag Archives: database

Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c

I’ve spent the last couple of evenings playing with the new SQL pattern matching feature in Oracle 12c. Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c Release 1 (12.1) I’m doing some sessions on analytic functions in some upcoming conferences and I thought I should look at this stuff. I’m not really going to include much, […]

Roll up! Roll up! Nothing new to see here! (Database Web Services)

Over the years I’ve written loads of stuff about consuming and publishing web services directly from the database. I’ve been doing quite a bit of this at work recently and I realised how difficult it is to find all the pieces, since they are spread across multiple articles, spanning multiple database versions. In an attempt to […]

JSON Support in Oracle Database 12c (12.1.0.2)

I spent a bit of time at OpenWorld looking at the JSON support in Oracle Database 12c. I started to write some stuff about it on the plane home and I spent the last two mornings finishing it off. You can see the results here. JSON Support in Oracle Database 12c Release 1 (12.1.0.2) Indexing JSON […]

Temporal Validity, ACLs, External Tables, SQL*Loader and more in Oracle 12c

Some more 12c articles have trickled out over the last few days. Temporal Validity in Oracle Database 12c Release 1 (12.1) Fine-Grained Access to Network Services Enhancements in Oracle Database 12c Release 1 External Table Enhancements in Oracle Database 12c Release 1 (12.1) SQL*Loader Enhancements in Oracle Database 12c Release 1 (12.1) I kind-of mentioned this […]

A few more 12c articles

A few more 12c articles went live over the last few days… Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1) Invisible Columns in Oracle Database 12c Release 1 (12.1) In-Database Archiving in Oracle Database 12c Release 1 (12.1) The DMU and In-Database Archiving are from the OCP syllabus. The Invisible Columns […]

Oracle Database 12c Release 1 (12.1.0.2) Patch Released

I just read this post by Dirk Nachbar, saying that 12.1.0.2 is now available from edelivery.oracle.com. I’ve downloaded it, so the rest of the world is now allowed to start their downloads. I assume it will be available from MOS also at some point. Cheers Tim… PS. It will allegedly be made available on OTN […]

Invoker Rights in Oracle Database 12c : Some more articles

I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back. Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1) I’ve recently “completed the set” by looking at the INHERIT PRIVILEGES and BEQUEATH CURRENT_USER stuff for PL/SQL code and […]

Automatic Diagnostics Repository (ADR) in Oracle Database 12c

There’s a neat little change to the Automatic Diagnostics Repository (ADR) in Oracle 12c. You can now track DDL operations and some of the messages that would have formerly gone to the alert log and trace files are now written to the debug log. This should thin out some of the crap from the alert log […]

Articles on Oracle Database 12c Multitenant Option

From a technology perspective, the Multitenant option is really cool, but it can be rather difficult to get to grips with some aspects of it. Everything is so intertwined and every feature in 12c somehow links back to the Multitentant option. As I’ve been working my way through the features the same pattern keeps repeating. […]

Data Pump Enhancements in Oracle Database 12c

Another one to file under “Not sexy but flippin’ awesome!” If you are a DBA, you are going to spend a lot of time with Data Pump. All roads seem to lead back to it. There are some more headline worthy features, like transportable database, but the two that jumped out at me were actually […]