My following query :

insert into acteursenc (nuacteur,nomacteur)
                    (select AA, BB from
                    (select max(nuacteur)+1 AA from acteursenc),
                    (select 'Michael Sweeney' BB from acteursenc))"

produces an ORA-00001: unique constraint error.

The primary key is nuacteur, but by setting AA to max(nuacteur)+1 I should
be getting a new key that is unique, however it does not seem that way.

What am I doing wrong here?

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to