Re: Autonumbering

Erm - this is getting very deep, isn't it?

A trigger - to answer the other thread - is a piece of code which is fired by the database automatically upon a particular action: typically, this would be upon inserting a record into a table, in your case. You need if you want to save the trouble of referring specifically to your sequence each time you insert records.

Regarding your questions below: Oracle stores all objects within it's datafiles. To recreate the database on another server, you could restore a backup of these datafiles from the original source.

I can't help you much more with this: can I suggest you either get some Oracle training, or follow a good book. The rating system used by Amazon could point you to some good ones.

Sorry!

Kingsley

kev wrote in message <379C8C1B.29680BDA_at_fast.no>...
>Kingsley Sawyers wrote:
>
>> Create the SQL command you want and execute it when the database
(instance)
>> is running. This creates the Sequence object, for evermore.
>
>What if I have to move the database to another server, or create it again
from
>scratch for some reason?
>I intend to have a database creation script for this very reason. Would it
be
>wise to put the sequence declaration statement in here, or is there some
other
>initialisation file for this purpose?
>
>Ta,
>
>- Kev
>
Received on Tue Jul 27 1999 - 06:07:36 CDT