Re: AW: [PHP] Oracle question

PL/SQL code for an Oracle trigger that will auto-increment specified field: create or replace trigger before insert on for each row begin if :new. is null then select .nextval into :new. from dual; end if; end; You have to create a sequence first. Example: CREATE SEQUENCE

AW: [PHP] Oracle question

oracle does not have an autoincrement. it has the more powerfull concept of TRIGGERS unfortunatelly you have to write them in pl/sql or java... have a look on the net for oracle trigger tutorial or you can find a super oracle-feature-documentation here : http://conf.php.net/oci2 http://conf.php.