Oracle database
Oracle Database Release 12c (12.1) introduced a new operator that we can use in SQL queries. The MATCH_RECOGNIZE operator allows…
Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2.…
One of those things SQL developers are frequently looking at is the generation of rows: having a query return records…
A brief headsup for everyone responsible for maintaining kernel options in the oracle executable. The environment where I discovered this…
![2018836700[1]](https://i0.wp.com/technology.amis.nl/wp-content/uploads/2015/01/20188367001.jpg?resize=351%2C185&ssl=1 "One of the many nice new features in 12c database: code based access control")
Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it.…
Oracle NoSQL Database is an interesting option to consider when you want a schemaless, fast, scale-able database which can provide…
Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT…
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem.…
Oracle introduced the ODA X6-2S and ODA X6-2M. And no, they are not the successor of the quite popular ODA…
Views in the Oracle database have several uses. You can use them to provide a view of data in different…
In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In…
My Oracle Public Cloud DBaaS instance did not respond. On closer investigation, it turned out to be down. Mounting the…
Some months ago I worked on a project where we thought it would be a good idea to use multiple…
In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In…
In this Blog I will explore the possibilities to apply Continuous Delivery (CD) for the Oracle database. What is Continuous…
Heard about it at Oracle OpenWorld 2015: A new feature in Oracle Enterprise Manager 13c is the possibility to incorporate…
JDBC URLs used in JDBC database connections in IDEs like JDeveloper and in JDBC Data Source definitions in Java EE…
After a database instance is provisioned in the DBaaS cloud service, it is not automatically accessible from services outside the…
In this article I will tell you how to get up and running with the Oracle Database as a Service…
note: I would like to thank Mark Rittman of RittmanMead for sharing many of this findings from Oracle OpenWorld 2015…
