Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Creating Sequence for Auto Number
I am trying to create a sequence to auto number a column in a table.
There is a small section on it in the ORacle book I am reading but it
is not detailed enough for me to try it.
I know I have to use the 'create sequence' command and something called
the NextVal thingie.
Would I have to create some sort of trigger(something else I don't know
how to do) to tell the data to increment on say an insert, update?
Thanks for any help
Jim
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 20 2000 - 10:29:11 CST