1. 建一张表,比如persons,保证表中有id字段,SQL语句如下:
CREATE TABLE PERSONS
(
ID NUMBER,
LASTNAME VARCHAR2(15 BYTE) NOT NULL ENABLE,
FIRSTNAME VARCHAR2(15 BYTE) NOT NULL ENABLE,
ADDRESS VARCHAR2(20 BYTE),
CITY VARCHAR2(20 BYTE)
)
2.d对id字段建立sequence和trigger,语句如下:
create sequence persons_id increment by 1 minvalue 1 start with 1 nocache;
create or replace trigger persons_trigger
before insert on persons
referencing old as old new as new for each row
begin
select persons_id.nextval into :new.id from dual;
end;