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.
http://www.oracle.com/technology/oramag/oracle/02-sep/o52sql.html
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
