Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

apex

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
Oracle Developement 

Speaking at RMOUG Training Days 2014

February 3, 2014 cruepprich apex, application express, authentication, authorization, oracle, plsql, presentation, rmoug, security

I’m honored to be allowed to present at this year’s RMOUG Training Days. My presentation Making Sense of Application Express Security,

Read more
Oracle Developement 

Enkitec APEX Resource Center

December 18, 2013 cruepprich apex, application express, oracle, pl/sql

I’m proud to announce the launch of the Enkitec APEX Resource Center (aka ARC) this week. It consists of a

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 Application Express (Apex) Oracle Developement 

Getting and setting Apex page item values using $v(), $s(), $v2()

January 11, 2013 cruepprich apex, application express, javascript, oracle

The Apex JavaScript API has some very convenient functions to access the values of page items. For example, if you

Read more
Oracle Application Express (Apex) Oracle Developement 

Getting started with PL/PDF in Oracle Application Express

December 14, 2012 cruepprich apex, application express, oracle, pdf, plpdf

PL/PDF (www.plpdf.com) is a PL/SQL library for Oracle, which allows you to generate PDF documents. You can use these libraries

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

LDAP Authentication with APEX

November 2, 2012 cruepprich apex, application express, authentication, ldap, oracle

Here is a quick tutorial on how to set up LDAP authentication with Oracle Application Express 4.1.1. Let’s assume that

Read more
Oracle Application Express (Apex) Oracle Developement 

Login/Logout Handling in Apex 4.1.1

August 30, 2012 cruepprich apex, application express, oracle

With the Apex 4.1.1 patch, some behavior in the login/logout processing has changed. Login In our application we use the

Read more
Oracle Application Express (Apex) Oracle Developement 

Bug in Apex 4 when defining custom flash chart colors.

August 24, 2012 cruepprich apex, application express, bug, colors, oracle

In Apex 4.1.1, when you specify custom colors in a Flash chart, and the custom color list contains blank spaces,

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