PL/SQL - AMIS Oracle and Java Blog

Browsing: PL/SQL

Databases

June 12, 2017 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…

May 5, 2017 0 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…

February 24, 2017 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…

February 23, 2017 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…

AMIS

January 24, 2017 0 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…

September 5, 2016 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.…

July 31, 2016 1 Virtual Private Database…

Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem.…

Agile

April 22, 2016 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…

PL/SQL

April 20, 2016 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…

Agile

April 15, 2016 2 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…

December 22, 2015 9 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…

March 13, 2015 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…

March 9, 2015 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…

October 1, 2014 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…

April 3, 2014 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,…

March 31, 2014 0 Using Table Functions

Overview of table functions Table functions are functions that produce a collection or rows (either a nested table or a…

February 28, 2014 2 Typical

After a presentation by Lucas Jellema I decided to try something with types in Oracle. One of the issues posed…

January 17, 2014 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.…

January 14, 2014 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…

December 30, 2013 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…

1 2 3 … 24 Next