The Moto behind for Creating this Blog is to share the concepts Of Oracle Database.In This Blog,The Information is gathered from Metalink,Expert's Blog and Oracle Documentaion.It Includes Real Time Scenarios,Oracle9i concepts,Oracle10g Concepts,RAC,Streams,Replication...
Please do visit my blog and post your comments & advice please.
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.