Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: travel time policy? corporate and consultants

Re: travel time policy? corporate and consultants

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 13 Apr 2004 22:53:20 +0100
Message-ID: <0sno705hku22t2rbc3co0edfblf5todoas@4ax.com>


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/space
Received on Tue Apr 13 2004 - 16:53:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US