Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

pl/sql

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 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, 2012 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, 2012 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
Oracle Application Express (Apex) Oracle Developement PL/SQL 

Quick Look: How to loop through an associative array indexed by varchar2.

April 16, 2012 cruepprich apex, application express, array index, arrays, associative array, collections, loop, oracle, pl/sql, pls/sql, plsql, programming, sql, table

Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2: [sourcecode language=”sql”]

Read more
Oracle Developement PL/SQL 

Regular expression to parse out numbers with optional precision.

March 29, 2012 cruepprich oracle, pl/sql, plsql, regex, regular expression

This regular expression will parse out numbers with or without decimals. In this case, the number has to be surrounded

Read more
Oracle Developement Oracle Tools PL/SQL 

QDT: Escape from Alcatraz

February 3, 2012 cruepprich datapump, oracle, pl/sql, plsql

Quick Datapump Trick Using the expdp/impdp datapump utilities on Unix/Linux can be a bit tricky when it comes to formulating

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