Bit of a problem, Help please!

I have a customer table that I have created in Oracle. This is linked to a web page via cgi script. Which inserts customer details from a HTML form to an oracle database.

The details cannot be inserted without customer ID. This customer ID needs to be auto_incremental. How do I make the cgi or the database auto_increment a customer number.

Cheers

JackD

One way is to user oracle sequence,

Create Sequence seq_name increment by 1 start with 1 nomaxvalue nocycle nocache;

then,

Create or replace trigger trig_name before insert on customer for every row
declare
a number(7);
begin
select seq_name.nextval into a from dual;
:new.CustID = a;
end;
/



Alternatively, code the above trigger as
select max(CustID) into a from Customer;
:new.CustID = a + 1;


Now, just forget inserting CustID for new records,

Regards, SeaBird.

Please use descriptive subjects in your posts!