Re: query requirement

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: sjaffarhussain@xxxxxxxxx
  • Date: Wed, 18 May 2005 09:44:06 -0700

In addtion to Tim's excellent suggestion, you might like to
look at Jonathan Gennick's article on this subject.

On 5/17/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote:
> 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

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


Other related posts: