Re: Optimising PL/SQL Script. Takes 2 days to run.

From: Hanspeter 'Happl' Oberlin <happl_at_mail.com>
Date: Thu, 23 Jan 2003 09:57:04 +0100
Message-ID: <happl-2E6DF2.09564723012003@chello212017086164.14.vie.surfer.at>

In article <7f966bc5.0301220521.104eb3e4_at_posting.google.com>, david_at_fitzg.com (David FitzGerald) wrote:

>> start_date := to_date('23012003','ddmmyyyy');
>
>What difference does this make? Is it purely good form to do it like
>this or is there a speed boost?

I don't think it brings much performance improvements But it is portable accross databases with different NLS and language settings.

Greetings from Switzerland -- Gruesse aus der Schweiz Happl Received on Thu Jan 23 2003 - 02:57:04 CST