Re: about SYSDATE function

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Tue, 03 Apr 2001 00:44:51 -0700
Message-ID: <3AC97F73.3017D4A7@ntsource.com>

One way to cut down on repeated references to sysdate, user or whatever is to store these values into global variables when the web page is displayed or the value is initially required and then reference the globally defined values afterwords.

Frank Hubeny

Jonathan Lewis wrote:

>
> (It'll be nice when it is corrected - there is a webserver
> system I support where the most expensive statement
> is SELECT SYSDATE FROM DUAL, and the second
> is SELECT USER FROM DUAL).
>
Received on Tue Apr 03 2001 - 02:44:51 CDT