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;

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

Xia Zhang said...

http://www.shopbestgoods.com/
http://www.bestcustomsonline.com/
http://www.nike-jordanshoes.com/
http://www.polo-tshirts.com/
http://www.burberry-factory.com/
http://www.kate-spades.com/
http://www.barbour-factory.com/
http://www.coachlosangeles.com/
http://www.official-coachoutlet.com/
http://www.louisvuittonas.com/
http://www.burberryoutlet2014.com/
http://www.official-mkoutlet.com/
http://www.official-pradaoutlet.com/
http://www.beatsbydreoutlet.net/
http://www.michaelkorsonlineusa.com/
http://www.northsclearance.com/
http://www.ralph-laurensale.com/
http://www.gucci-shoesuk2014.com/
http://www.michael-korsusa.com/
http://www.polo-outlets.com/
http://www.hermes-outletonline.com/
http://www.ralphslauren.co.uk/
http://www.marcjacobsonsale.com/
http://www.mcmworldwides.com/
http://www.warmbootssale.com/
http://www.salongchamppairs.com/
http://www.canada-gooser.com/
http://www.michaelkors.so/
http://www.oakley-sunglassoutlet.com/
http://www.north-faceoutlets.net/
http://www.moncler-clearance.com/
http://www.woolrich-clearance.com/
http://www.barbour-jacketsoutlet.com/
http://www.moncler-jacketsoutletonline.com/
http://www.monsterbeatsbydres.net/
http://www.lv-guccishoesfactory.com/
http://www.cheapdiscountoutlet.com/
http://www.coachsfactoryoutlet.com/
http://www.coach-blackfriday2014.com/
http://www.coach-storeoutletonline.com/
http://www.coach-factorysoutletonline.com/
http://www.coachccoachoutlet.com/
http://www.coach-factories.net/
http://www.coach-pursesoutletonline.com/
http://www.coach-outletsusa.com/
http://www.zxcoachoutlet.com/
http://www.mischristmas.com/
http://www.misblackfriday.com/
http://www.newoutletonlinemall.com/
http://www.ralphlaurenepolo.com/
http://michaelkorsoutlet.mischristmas.com/
http://mcmbackpack.mischristmas.com/
http://monsterbeats.mischristmas.com/
http://northfaceoutlet.mischristmas.com/
http://mk.misblackfriday.com/
http://coachoutlet.misblackfriday.com/
http://coachfactory.misblackfriday.com/
http://uggaustralia.misblackfriday.com/
http://coachpurses.misblackfriday.com/
http://coachusa.misblackfriday.com/
http://coach.misblackfriday.com/
http://michaelkorss.misblackfriday.com/
http://michaelkors.misblackfriday.com/
http://airmax.misblackfriday.com/
http://michael-kors.misblackfriday.com/
https://twitter.com/CoachOutlet2014
https://www.facebook.com/coachoutletstoreonline
https://www.facebook.com/ralphlaurenoutletonline

John Smith said...

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

John Smith said...
This comment has been removed by the author.
John Smith said...

Thank you for sharing such interesting and informative article.


Best Lipo Cleanse

dong dong23 said...

retro jordans
cheap jordans
polo ralph lauren
longchamp outlet
gucci handbags
oakley sunglasses
ralph lauren
louis vuitton bags
louis vuitton handbags
toms outlet
cheap jerseys
adidas stan smith
supra shoes
louis vuitton outlet
tods outlet
hollister uk
michael kors outlet
louis vuitton outlet
oakley sunglasses
replica watches
tory burch sale
kate spade handbags
michael kors outlet online
nike uk
louis vuitton
giuseppe zanotti
fitflop sandals
michael kors outlet online
gucci handbags
kate spade handbags
hollister clothing
ray bans
coach factory outlet
nike roshe run
celine
jordans for sale
celine
hollister clothing
marc jacobs
christian louboutin shoes
20166.4wengdongdong

aaa kitty20101122 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

郑佳颖 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...

ferragamo belt
adidas store
yeezy boost 350 v2
tom ford glasses
gucci belt
ultra boost
fitflops
kobe 9
nike air force
michael kors factory 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