PL/SQL – Page 3 – Christoph's 2 Cents

Oracle Application Express (Apex) Oracle Developement PL/SQL

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

April 16, 2012November 16, 2022 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:

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

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

Next →