Topic |
Description |
|
| 15/10/2007 | Looking to reinvent SUBSTR ? Maybe use the SUBSTR function :-) |
|
| 15/08/2007 | Handling bulk collect with PLSQL record datatypes |
|
| 16/07/2007 | Good but not good enough for INSERT |
|
| 20/06/2006 | Using collections to spice up SQL |
|
| 11/01/2006 | How to alter a type without dropping and recreating it |
|
| 08/09/2005 | Some hidden costs with NVL you might not expect |
|
| 14/06/2004 | Just a reminder about DBMS_SQL overuse |
|
| 04/02/2004 | Staying efficient with PL/SQL upsert |
|
| 04/12/2003 | File deletion in version 8i |
|
| 08/08/2003 | Surely the worst piece of PL/SQL code ever |
|
| 01/01/2003 | (Updated) A faster SYSDATE then SYSDATE |
|
| 21/06/2002 | A simple mechanism for increasing the speed SQL within PL/SQL |
|
| 24/04/2002 | (Updated)Fetching into a PL/SQL table in a single call |
|
| 03/03/2002 | (Updated)When using counters in loops, for that extra little bit more speed, TRUNC is faster than MOD |
|
| 06/02/2002 | A 'gotcha' when using DBMS_LOB.LOADFROMFILE |
|
| 11/11/2001 | Defining a public and private component to a packaged cursor |
|
| 15/07/2001 | Putting to rest the myth about explicit cursors being better than implicit ones |
|
| 30/05/2001 | A faster SYSDATE then SYSDATE |
|
| 04/03/2001 | A (very) simple wrapper to ease use of DBMS_OBFUSCATION_TOOLKIT |
|
| 14/01/2001 | A "semi-autonomous" transaction in 8.1.7! |
|
| 02/01/2001 | You were never meant to do this anyway...but now 8.1.7 stops you! |
|
| 19/12/2000 | A weird bug in PL/SQL in 8.1.7 (that will cause you grief if you use Designer) |
|
| 06/07/2000 | A PL/SQL encryption routine to tide you over until 8i.2 |
|
| 12/04/2000 | Reclaiming the memory used by large PL/SQL tables |
|
| 04/04/2000 | A nifty little (undocumented) PL/SQL package for tracing |
|
| 29/03/2000 | An undocumented PL/SQL procedure to give more flexibility to your tracing |
|
| 16/02/2000 | A PL/SQL function to perform checksums |
|
| 09/02/2000 | Bitwise calculations in Oracle with the 'bitand' function |
|
| 06/02/2000 | Using the CUBE and ROLLUP features in PL/SQL |
|
| 06/02/2000 | Retreiving a GIF image from a database column and showing on a web page |
|
| 06/02/2000 | You can use PL/SQL to write your own messages to the alert.log |
|
(always more to come...) |
|