Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

Oracle Application Express (Apex)

shallow focus photography of computer codes
Oracle Application Express (Apex) Oracle Tools ORDS 

ORDS Standalone: Configure SSL Certificate Chain

August 30, 2021August 30, 2021 cruepprich

This post describes the process for installing an SSL certificate chain in ORDS running in Standalone mode. Prerequisites: One instance

Read more
green plant covered with snow
APEX Cloud DevOps Linux Oracle Application Express (Apex) Oracle Cloud Infrastructrure Oracle Developement Oracle Linux 

Run ORDS as a systemd Service

February 22, 2021February 22, 2021 cruepprich

In this example, I configure ORDS to run as a systemd service. This way ORDS runs in the background and

Read more
Ajax APEX Cloud JavaScript Oracle Application Express (Apex) Oracle Developement PL/SQL 

APEX: Fetch CLOB data via AJAX callback.

April 6, 2020April 9, 2020 cruepprich ajax, apex, apex.ajax.clob, application express, callback, dynamic action, javascript, oracle, pl/sql

In my use case, I needed to fetch data (JSON) larger than 32k into a JavaScript variable. In APEX versions

Read more
Oracle Application Express (Apex) Oracle Developement 

APEX 5 Theme/Static files issue (503 error)

September 7, 2016 cruepprich 503, apex_listener, apex_rest_public_user, failed to load resource, static files, theme

I’ve recently come across the issue of static images not working and my custom theme roller theme not being applied

Read more
Oracle Application Express (Apex) Oracle Developement PL/SQL 

Color Spectrum in APEX report

April 22, 2016 cruepprich css, javascript

I recently had the need to display a color spectrum, depending on a column value, in a report. The colors

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools PL/SQL 

SQL Developer SSH connection

April 21, 2016 cruepprich cloud, ssh

If you have to access databases that can only be reached through SSH connections, you can configure SQL Developer (4.1)

Read more
Oracle Application Express (Apex) Oracle Developement PL/SQL 

APEX 5: Convert Skillbuilder’s Modal to Universal Theme

June 1, 2015 cruepprich apex, application express, javascript, jquery, oracle, orclapex, pl/sql

If you have implemented the Skillbuilder’s Modal Page Plugin in an application of a previous version of APEX, and want

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Performance Oracle Tools PL/SQL 

SQLd360 v3 now available, new features and (hopefully) less bugs!

February 27, 2015 cruepprich

SQLd360 v3 now available, new features and (hopefully) less bugs!.

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools 

Excel Style Row Numbering in SQL

February 3, 2014 cruepprich apex, application express, connect by, hierarchy, level, oracle, pl/sql, plsql, row numbering, sql

Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.

Read more
Linux Oracle Application Express (Apex) Oracle Developement Oracle Tools 

Configuring Apex Listener Version 2

February 21, 2013 cruepprich

“Where is the listenerConfigure page?” That seems to be a common question when people attempt to deploy the Apex Listener

Read more
  • ← Previous
Oracle ACE
Copyright © 2023 Christoph's 2 Cents. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.