0 ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server
While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot…
Browsing: PL/SQL
1 Golden Gate 12c and DIY Sequence Replication with PL/SQL
Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by…
1 Dump Oracle data into a delimited ascii file with PL/SQL
This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to…
3 DIY Parallelization with Oracle DBMS_DATAPUMP
Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In…
1 Oracle 12c STIG Password Generator in PL/SQL
Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find…
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.…
1 Virtual Private Database…
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem.…
0 Continuous Delivery and the Oracle database (III)
In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In…
4 Parse JSON Array in SQL and PL/SQL – turn to a Nested Table
Transferring data between technologies and application tiers is done using various formats – binary, native on the one hand and…
4 Continuous Delivery and the Oracle database (II)
In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In…
11 as_json: Relational to JSON in Oracle Database
Some time ago I noticed this blog from Dan McGhan. In that blog he compares several ways to generate JSON…
2 Using an aggregation function to query a JSON-string straight from SQL
Last week I read this blogpost by Scott Wesley. In this post he describes that he uses a custom aggregate…
0 How-to set the current database schema of an application using a global context
Question: We have customers who want to work with different database schemas and we want to determine dynamically – depending…
15 FTPS with PL/SQL
Doing a FTP-job with PL/SQL is not difficult. A basic implementation of RFC 959 can be written in a few…
0 PL/SQL vs SQL
There is a ‘rule’, I think it was created by Tom Kyte, stating: If you can do it in SQL,…
0 Using Table Functions
Overview of table functions Table functions are functions that produce a collection or rows (either a nested table or a…
0 ADF Performance Tuning: Improve Your Oracle ADF App Response Time by as Much as 70 Percent
Performance needs to be ingrained in your application – it cannot be added in during the last stages of development.…
0 ADF performance tuning: Overview Video published on the ADF Performance Monitor
A good performance is the key to the success of a web application. Oracle ADF applications are no exception to…
0 Easy setup of the query_partition_clause of row_number() for dedup(lication)
Finding and getting rid of duplicate records in a table is easy…. The row_number() over ( <query_partition_clause> <order_by_clause> ) analytic…