Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

plsql

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

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

Copying one associative array to another.

May 9, 2012November 16, 2022 cruepprich oracle, pl/sql, plsql

If you have two associative arrays (PL/SQL tables), and want to copy the contents of one to another, rather than

Read more
Oracle Developement PL/SQL 

Send email through Gmail

May 3, 2012 cruepprich oracle, pl/sql, plsql

Send email through Gmail

Here is an excellent article on how to send email through PL/SQL, using Gmail as the smtp server.

Read more
Oracle Developement PL/SQL 

DBMS_RESOURCE_MANAGER and Apex

April 18, 2012 cruepprich oracle, pl/sql, plsql

DBMS_RESOURCE_MANAGER and Apex

Here is an excellent post by Joel Kallman on how to use DBMS_RESOURCE_MANAGER to control the impact Apex has on the database.

 

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