Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff

PL/SQL

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

Neat little comment trick.

November 7, 2012 cruepprich development, oracle, pl/sql

I often have some test code that spans multiple lines in my PL/SQL programs that I need to comment/un-comment frequently.

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

Apex: Accessing Tabular Form Column Values

July 26, 2012 cruepprich apex, application express, oracle, reports

I created a tabular report on a table and needed to write some custom code that does some DML based

Read more
Oracle Developement PL/SQL 

Controlling SYSDATE

July 9, 2012 cruepprich oracle, pl/sql, plsql, sysdate

For certain testing scenarios, I need to have SYSDATE return a certain date. This can be done with Oracle’s FIXED_DATE

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

Logarithmic Apex Charts

May 25, 2012November 17, 2022 cruepprich apex, application express, charts, flash, oracle, pl/sql, plsql

If you have a chart with a large difference between the highest and lowest values, you may find that the

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