Automatic generation of IDs using Trigger,sequence in Oracle

http://zhanghong.iteye.com/blog/865937

1. Create a database table first

Sql> CREATE TABLE Customer (

2 ID Number (8) NOT null primary key,

3 name VARCHAR2 (20),

4 Age Number (3),

5 gender VARCHAR2 (8)

6);

2. Create sequence:

Create sequence customer_sequence start with 6 increment by 1

3. Create TRIGGER:

Create or Replace Trigger Customer_trgger

Before insert or update on customer

For each row

Begin

Select customer_sequence. Nextval Into:NEW.userID from dual;

End

You don't have to provide an ID when inserting data.

Sql> INSERT into customer (Name,age,gender) VALUES (' abc ', ' Male ');

1 row created.