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;

10 comments:

sukumar said...

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?

Anonymous said...

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

Anonymous said...

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 ()

Unknown said...

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

Unknown said...
This comment has been removed by the author.
Unknown said...

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

Unknown said...

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

jeje said...

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

yanmaneee said...

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

senedou said...

n0u51j1k79 x5e25y7j67 t3t89w9c52 y6i90n1c78 k9p34u4k06 g2o69r5v65