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

Home -> Community -> Mailing Lists -> Oracle-L -> query requirement

query requirement

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Tue, 17 May 2005 15:31:17 +0300
Message-ID: <97b7fd2f05051705316be1afe@mail.gmail.com>


Good Day everyone!

We have one online table which gets a lot of insertions every second and there could no insertions sometimes, This table has one timestamp column which stores timestamp when an inserts take places. My requirements is, say there are insertions at 10:10:10 AM and the next insertion is at 10:11:10AM, i.e. there are no transactions take place from 10:10 to :10:11 am. When I use normal query which only display records which are exists for the stored timestamp. Is it possible that I write a query which see the next record and between timestamp is not 1 second says, no rocrd in this second.

Thanking you in advance for your valuable time. --=20
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia

---------------------------------------------------------------------------=


"It is your atittude, not your aptitude that determins your altitude."
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 17 2005 - 08:35:57 CDT

Original text of this message

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