Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: travel time policy? corporate and consultants
On Sun, 11 Apr 2004 12:48:12 +0100, Ed Avis <ed_at_membled.com> wrote:
>Oracle supports time travel? Oh, wait, never mind...
Flashback queries? ;-)
Although there are limitations;
SQL> SELECT *
2 FROM nationallottery
3 AS OF TIMESTAMP SYSDATE+1;
FROM nationallottery
*
ERROR at line 2:
ORA-08186: invalid timestamp specified
:-(
-- Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/spaceReceived on Tue Apr 13 2004 - 16:53:20 CDT