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_at_chello212017086164.14.vie.surfer.at>
Date: Thu, 23 Jan 2003 09:57:04 +0100
Message-ID: <happl-2E6DF2.09564723012003_at_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 - 09:57:04 CET