PL/SQL


Topic

Description

15/10/2007

PEBKAC substring

Looking to reinvent SUBSTR ? Maybe use the SUBSTR function :-)

15/08/2007

BULK records

Handling bulk collect with PLSQL record datatypes

16/07/2007

RETURNING clause

Good but not good enough for INSERT

20/06/2006

SQL and Collections

Using collections to spice up SQL

11/01/2006

Altering types (updated)

How to alter a type without dropping and recreating it

08/09/2005

NVL costs (updated)

Some hidden costs with NVL you might not expect

14/06/2004

DBMS_SQL

Just a reminder about DBMS_SQL overuse

04/02/2004

PL/SQL upsert

Staying efficient with PL/SQL upsert

04/12/2003

File deletion

File deletion in version 8i

08/08/2003

As bad as it gets

Surely the worst piece of PL/SQL code ever

01/01/2003

Fast SYSDATE

(Updated) A faster SYSDATE then SYSDATE

21/06/2002

Speed increase

A simple mechanism for increasing the speed SQL within PL/SQL

24/04/2002

Array fetch

(Updated)Fetching into a PL/SQL table in a single call

03/03/2002

MOD vs TRUNC

(Updated)When using counters in loops, for that extra little bit more speed, TRUNC is faster than MOD

06/02/2002

Loading LOBs

A 'gotcha' when using DBMS_LOB.LOADFROMFILE

11/11/2001

Packaged Cursors

Defining a public and private component to a packaged cursor

15/07/2001

Cursor speed

Putting to rest the myth about explicit cursors being better than implicit ones

30/05/2001

Fast SYSDATE

A faster SYSDATE then SYSDATE

04/03/2001

DES Encryption

A (very) simple wrapper to ease use of DBMS_OBFUSCATION_TOOLKIT

14/01/2001

Semi-autonomous?

A "semi-autonomous" transaction in 8.1.7!

02/01/2001

Fetch across commits

You were never meant to do this anyway...but now 8.1.7 stops you!

19/12/2000

PL/SQL in 8.1.7

A weird bug in PL/SQL in 8.1.7 (that will cause you grief if you use Designer)

06/07/2000

Encryption

A PL/SQL encryption routine to tide you over until 8i.2

12/04/2000

PL/SQL table memory

Reclaiming the memory used by large PL/SQL tables

04/04/2000

More on tracing

A nifty little (undocumented) PL/SQL package for tracing

29/03/2000

Tracing sessions

An undocumented PL/SQL procedure to give more flexibility to your tracing

16/02/2000

Checksum

A PL/SQL function to perform checksums

09/02/2000

Bit operations

Bitwise calculations in Oracle with the 'bitand' function

06/02/2000

Cube & Rollup in PL/SQL

Using the CUBE and ROLLUP features in PL/SQL

06/02/2000

Images to the web

Retreiving a GIF image from a database column and showing on a web page

06/02/2000

Writing to alert.log

You can use PL/SQL to write your own messages to the alert.log

(always more to come...)


All content on this page is provided on an "all care, no responsibility or liability" basis
The use of very basic html on this page is designed to increase the speed at which each page is downloaded.
It has nothing to do with my wealth of html knowledge :-)