Hello
We need to autoincrement VISITORID when we inserts something in the VISITOR
table and we use SEQUENCE
drop sequence VISITORID_seq;
create sequence VISITORID_seq start with 1;
-------------------------------------
create table VISITOR (
VISITORID
number DEFAULT VISITORID_seq.nextval UNIQUE, ???????????? ERROR!!
LOGINID varchar2
(32) NOT NULL UNIQUE,
PASSWORD_VALUE varchar2 (32),
CONFIRM_VALUE varchar2 (32),
FIRST_NAME
varchar2 (99) NOT NULL,
LAST_NAME
varchar2 (99) NOT NULL,
ADDRESS1 varchar2 (255),
Someone knows how to do this?
What
about to create a trigger to insert
VISITORID_seq.nextval into VISITORID?
saludos,
Sergio Rivas
Comercio Electr�nico B2B 2.000
|
