Re: set a number of records
From: M. Richardson <michael_at_iceic.com>
Date: Thu, 21 Jun 2001 16:49:21 GMT
Message-ID: <lApY6.6334$l_3.13707_at_news1.rochd1.qld.optushome.com.au>
Date: Thu, 21 Jun 2001 16:49:21 GMT
Message-ID: <lApY6.6334$l_3.13707_at_news1.rochd1.qld.optushome.com.au>
Hey,
I'm just wondering, what would you do if you wanted to set a limit on the number of records that can be inserted into a table. Ie - if tblname => 100 don't write data
Hope that makes sense :P
Cheers,
Michael.
"Tom Grenier" <tom_at_sqlman.com> wrote in message
news:3B31FE79.A6B47D46_at_sqlman.com...
> Select * from tablename where rownum <= 10;
>
> Fabien VERISSIMO wrote:
>
> > Hi,
> >
> > Could someone help me ?
> >
> > how set a number of records (a limit) in a SQL statement in ORACLE
("top"
> > doesn't operate, "limit" too...)
> >
> > thank you to help me
>
Received on Thu Jun 21 2001 - 18:49:21 CEST