Re: query requirement

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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: