Re: Query about inserting records

From: James Petts <jpetts_at_celltech.co.uk>
Date: Tue, 16 Feb 1999 13:56:22 GMT
Message-ID: <36c978cf.693548990@firewall.celltech>

On Tue, 16 Feb 1999 11:57:58 +0100, GreMa_at_t-online.de (Matthias Gresz) wrote:

>if you don't need a continious numbering use sequneces and triggers:

>Since sequences are cached in the SGA each database shutdown and restart
>will eat up some numbers.

Sequences can be created with no caching. Look at the syntax for CREATE SEQUENCE... Received on Tue Feb 16 1999 - 07:56:22 CST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

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