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: select changes in row values?

Re: select changes in row values?

From: aksel.schmidt <axl.schmidt_at_gmail.com>
Date: Wed, 27 Jun 2007 20:48:27 -0700
Message-ID: <1183002507.493893.104200@k79g2000hse.googlegroups.com>


there is an ordering - just left out for simplicity assume another column named 'timestamp' exists - some client is then asked to put a row in the table (timestamp, value) on a periodical basis. this timestamp value is continously incrementing and used for ordering the select

after a while, another client wants to retrieve only changes over time in those values (there are many other columns which values changes on each insert - it is thus not the inserting clients fault)

does it make sense now?

/aksel Received on Wed Jun 27 2007 - 22:48:27 CDT

Original text of this message

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