Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi_ss']
26-May-98 03:37 saropani_at_my-dejanews.com wrote:
:>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
What Oracle version? I use 7.3.3 and can't find nothing like you wrote above
Eugene Received on Thu May 28 1998 - 05:20:44 CDT