create table AS (coloma varchar2(10));
create sequence sequence_a .....
insert into AS (coloma) values (sequencea.nextval);
Hans
-----Original Message-----
From: luis
[mailto:oracledba-ezmlmshield-x99462741.[Email address protected]
Sent: woensdag 31 mei 2006 13:19
To: LazyDBA Discussion
Subject: Concept of a sequence
G's
I will try and make sense, but cannot guarantee it.
I want to have a unique incremental indentifier on records being
inserted. For every insersion there should be a column with this
indentifier and as a record is inserted this sequence to kick in and
insert the it's value into the table.
How can I relate a sequence to a table?
Am I going about it the right way?
Thanks,
Luis
This communication is intended for the addressee(s) only.
Please notify the sender if received in error. Internet email
is not to be treated as a secure means of communication.
Cheshire Constabulary monitors all Internet and email activity
and requires it is used for official communications only. Thank
you for your co-operation.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
Oracle LazyDBA home page