Oracle Database Archive - virtual7 GmbH

Finance Oracle Database Technology

Gedanken zum Datenbanktuning

Es kommt immer wieder es vor, dass (Oracle-) Datenbankanwendungen "zu langsam" sind. Dann wird versucht herauszufinden woran es liegt und wenn man Glück hat findet sich eine Idee das verursachende SQL-Statement so zu ändern, dass…

Jürgen Demuth31. März 2021

Finance Oracle Database Technology

Callgraphs for PL/SQL-Packages in Oracle

Motivation Did you ever had a foreign PL/SQL-Package in Oracle that was not documented but you needed to understand what is going on inside the package?There are tools on the market that could help you…

Jürgen Demuth26. März 2021

ADF general Javascript MAF Oracle Apex Oracle Cloud Oracle Database Oracle JET WebCenter Content WebCenter Portal

Nearshoring development with APEX

At the APEX Connect in Berlin, I had the chance to present the vision and best practices for nearshoring development in the context of APEX. Since 2004 we have been doing nearshoring development on different...

Ciprian N. Iancu9. Mai 2017

ADF Oracle Database

ADF BC: Central duplication of rows

Scenario – Historization with duplication of dependent rows In my current project we work a lot with historization and we use ADF Business Components to communicate with the DB in the model layer. If...

Marcus Hammer5. April 2017

Oracle Cloud Oracle Database

Oracle Database Cloud – SSH management

This is an article showing how to update the SSH keys on the Oracle Database Cloud instance. In my previous blog article I indicated two ways to connect to Oracle Database Cloud instance, the best...

Ciprian N. Iancu24. Februar 2017

Oracle Cloud Oracle Database

Oracle Database Cloud – tunneling

I finally received my Oracle Database Cloud free trial service, so it’s time to have some fun with it … The first thing you should try is to start the database and try to connect...

Ciprian N. Iancu14. Februar 2017

Oracle Database Oracle SOA Suite

Master-Detail-Select with DB-Adapter where Foreign Keys different from Primary Keys

Imagine that you want to use the Oracle Database Adapter of the Oracle SOA Suite in a BPMN 2.0 (Oracle BPM Suite) or BPEL (Oracle SOA Suite) scenario to retrieve master-detail data. The adapter normally...

virtual7 TEAM23. Dezember 2015

Oracle Apex Oracle Database

APEX 5 Upgrade issue

Description While upgrading APEX 4.1 to APEX 5.0 on database 11.2.0.3 and Oracle Embedded PL/SQL Gateway (EPG) an issue occurred. The installation didn’t work anymore. Following message was displayed before the login page was...

admin29. Oktober 2015