Toad World® Forums

Request: use of sysdate


When I want to test a program that uses sysdate as a internal check using the tool I had write in the initialization ALTER SYSTEM SET fixed_date = ‘2007-03-2-12:50:00’;
and in the finalization Alter System set fixed_date=‘none’ ;

what if the tool allowed this kind of parametrization, like a preference, to use as a default in every test case/program?

Of course the user need to have “alter system” permission (a litle security problems).


Thanks, Filipe. I will add this to our ER list.

Yes, needing ALTER SYSTEM is a big “show stopper”, but no reason that we cannot offer the option.