
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot…
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot…
Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by…
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to…
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In…
Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find…
Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it.…
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem.…
In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In…
Transferring data between technologies and application tiers is done using various formats – binary, native on the one hand and…
In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In…
Some time ago I noticed this blog from Dan McGhan. In that blog he compares several ways to generate JSON…
Last week I read this blogpost by Scott Wesley. In this post he describes that he uses a custom aggregate…
Question: We have customers who want to work with different database schemas and we want to determine dynamically – depending…
Doing a FTP-job with PL/SQL is not difficult. A basic implementation of RFC 959 can be written in a few…
There is a ‘rule’, I think it was created by Tom Kyte, stating: If you can do it in SQL,…
Overview of table functions Table functions are functions that produce a collection or rows (either a nested table or a…
Performance needs to be ingrained in your application – it cannot be added in during the last stages of development.…
A good performance is the key to the success of a web application. Oracle ADF applications are no exception to…
Finding and getting rid of duplicate records in a table is easy…. The row_number() over ( <query_partition_clause> <order_by_clause> ) analytic…