Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

PL/SQL

Cloud DevOps Groovy Jenkins Oracle Cloud Infrastructrure Oracle Developement Oracle Tools PL/SQL 

Jenkins Pipeline: Loop Multiple Databases

June 30, 2020June 30, 2020 cruepprich devops, groovy, jenkins, oracle, pipeline, plssql, sql

Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute

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 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 Developement Oracle Performance Oracle Tools PL/SQL 

Meet “edb360”: a free tool that provides a 360-degree view of an Oracle database

February 20, 2014 cruepprich optimization, oracle, performance, plsql, tuning

Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.

Read more
Oracle Developement PL/SQL 

Find ancestor from hierarchy

October 2, 2013March 4, 2022 cruepprich apex, connect by, grand parent, hierarchical, hierarchy, oracle, parent, pl/sql, plsql, query, reports, sql, traverse

I needed to find a quick way to select a particular ancestor for a child in a hierarchical table. For

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

Apex JSTree Nodes Remain Expanded After Page Refresh

February 13, 2013 cruepprich apex, jstree, navigation, oracle

To prevent a navigation JSTree to collapse after the page has been submitted, you need to have a page or

Read more
Oracle Developement PL/SQL 

Using Notepad++ with PL/SQL

January 14, 2013 cruepprich oracle, pl/sql, plsql

http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files

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