of sequence and trigger?
Much simpler...
depends on what your requirements are
Mark
Ben
-Original Message-
From: Mark Woods [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 10:42 AM
To: CF-Talk
Subject: Re: autonumbering in oracle
standard way is to create a sequence
Farrah,
Oracle doesn't have an autonumber datatype like MS Access does.
Instead, it has a feature called a sequence -- you use the CREATE SEQUENCE
command.
There was a cf-talk thread on this recently (4/2/01) -- try searching the
archive.
If you can't find it, let me know and I'll send you some
First, you must set up a sequencing table using Enterprise Manager, DB
Studio, or whatever tool you use to manage your Oracle database (Or tell
your DB Admin you need a sequencing table.) Then, you call this table when
you insert your next record:
INSERT INTO yourTable
(ID, Col1, Col2)
VALUES(
standard way is to create a sequence and then use a trigger when inserting
a row into the table, rather than explain any further, here's some code...
/* dummy table */
CREATE TABLE test (
ID integer NOT NULL ,
sometext varchar2(50) NOT NULL ,
PRIMARY KEY (ID)
editions of the book for various releases of
Oracle.)
-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 11:06 AM
To: [EMAIL PROTECTED]
Subject: [Re:] RE: autonumbering in oracle
hi ben,
i am totally new to oracle and please excuse me for a further
Woods [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 10:42 AM
To: CF-Talk
Subject: Re: autonumbering in oracle
standard way is to create a sequence and then use a trigger when inserting
a row into the table, rather than explain any further, here's some code...
/* dummy table */
CREATE
6 matches
Mail list logo