How to change
sysdate?
I want to make a function
whitch return sysdate or another date recorded in
database.
This function doesn't have
parameter but a persistent variable is need for
make choose
Ans1:
If you want a persistent variable
you will have to use a package. Take
a look at "Advanced Oracle
PL/SQL: Programming with Packages" by
Steven Feuerstein, publishe
by O'Reilly.
Ans2:
The function sysdate is system
function and you could not change it any way.
You may try to set fixed date
by appling parameter FIXED_DATE in init.ora. In
this way the sysdate return
fixed value, not depend on system time.