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

Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting a # of rows in the table

Re: Limiting a # of rows in the table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 18 Oct 2000 11:24:39 +0100
Message-ID: <971865547.1175.0.nnrp-10.9e984b29@news.demon.co.uk>

No.

There are a number of other horribly inefficient things you could do. How many rows do you want in the table, and how fast should the process go, and what do you want to do about updates and deletes, how secure is your database from tinkering? The answers affect the options.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

NetComrade wrote in message <380a2e95.14873927_at_news.earthlink.net>...

>is creating a trigger before insert and incrementing a # of rows for
>every insert and checking that number before every insert the only
>way?
>
>Thanx.
Received on Wed Oct 18 2000 - 05:24:39 CDT

Original text of this message

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