Re: What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi

From: <saropani_at_my-dejanews.com>
Date: Tue, 26 May 1998 03:37:27 GMT
Message-ID: <6kdddn$36o$1@nnrp1.dejanews.com>

In article <x70UZg4h9GA.249_at_newsfeed.netsgo.com>, "ÀÌ±¤¿ì(Lee,KwangWoo)" <leewin_at_netsgo.com> wrote:
>
> What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi_ss'] ?
> What is mean [alter system set gc_defer_time = integer] ?
>
> Lee,KwangWoo (leewin_at_netsgo.com)
>
>

Hi Lee,

There is a Initialization parameter FIXED_DATE. If you set this parameter to some date value, then all your 'SELECT SYSDATE.....' query will return the date you set, rather than the current date. This parameter is useful when debugging. I beleive the same happens with the 'ALTER SYSTEM SET FIXED_DATE..'

Regards,
Saravanan (saro_at_psoux141.sgp.hp.com)

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 25 1998 - 22:37:27 CDT

Re: What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi_ss']