If you are using Oracle 10g or greater, you can query the database tables as of a certain time using their Flashback technology. This is great if you had some data deleted and you do not want or cannot restore a full backup to retrieve the lost data.
Continue reading Another feature I wish SQL Server had: as of timestamp
Jim Salasek's SQL Server Blog 