Tuesday, October 9, 2007

Setting SYSDATE to Fixed Date & time

Login as SYS in SQL *Plus.

Issue the following command.

alter system set fixed_date='dd.mon.yyyy hh24:mi:ss';

This will alter the sysdate to always the date set.

To reset this to normal issue the following command.

alter system set fixed_date=NONE;
at

10 comments:

  1. sukumarSeptember 2, 2011 at 2:28 PM

    But here, we need to keep the changed date permanently. How can we do that? By writing the trigger? how can we write the trigger?

    ReplyDelete
  2. AnonymousJune 7, 2013 at 8:48 PM

    After looking over a handful of the blog articles on your site, I
    honestly like your technique of writing a blog.
    I added it to my bookmark site list and will be checking back soon.

    Take a look at my website as well and tell me your opinion.



    Lipo slender info

    ReplyDelete
  3. AnonymousJune 15, 2013 at 9:11 AM

    The hulk is incredible whereas the guy of steel is merely super.
    Extraordinary beats super any day

    my web page - will premature ejaculation cause pregnancy ()

    ReplyDelete
  4. UnknownJanuary 12, 2015 at 12:27 PM

    Thank you for sharing such wonderful and interesting article about Best Lipo Cleanse.

    ReplyDelete
  5. UnknownFebruary 11, 2015 at 11:39 AM

    This comment has been removed by the author.

    ReplyDelete
  6. UnknownAugust 11, 2017 at 8:56 PM

    michael kors outlet store
    air jordan
    reebok shoes
    jordan shoes
    nike air force 1
    yeezy shoes
    adidas outlet
    hogan outlet online
    louboutin shoes uk
    adidas ultra boost

    ReplyDelete
  7. UnknownSeptember 27, 2017 at 8:13 PM

    retro jordans
    vibram fivefingers
    michael kors outlet
    nike mercurial vapor
    chrome hearts online
    nike mercurial
    links of london sale
    hogan outlet online
    converse shoes
    michael kors outlet

    ReplyDelete
  8. jejeNovember 13, 2017 at 6:55 PM

    asics running shoes
    huarache shoes
    kyrie irving shoes
    vibram fivefingers
    vans store
    adidas tubular
    fitflops
    dior sunglasses
    lacoste online shop
    patriots jerseys

    ReplyDelete
  9. yanmaneeeDecember 17, 2020 at 9:33 AM

    ggdb
    yeezy boost 350 v2
    yeezy
    bape
    curry 8 shoes
    golden goose outlet
    curry shoes
    kobe shoes
    lebron james shoes
    hermes birkin

    ReplyDelete
  10. senedouSeptember 7, 2022 at 2:58 AM

    n0u51j1k79 x5e25y7j67 t3t89w9c52 y6i90n1c78 k9p34u4k06 g2o69r5v65

    ReplyDelete