violating unique constraint

[sammybee77]

Please help

I'm trying to update 4 fields in 2 tables in one hit with a not exists clause to ensure I don't violate the primary key constraint. I'm referencing data in 3 tables to do this - Any ideas? Should it be an insert or update statement?

 

[sem]

You can not update 2 tables by 1 statement: sql syntax prohibits this.
You may create a view and write instead-of trigger, but afaik read consistency is not guaranteed in this case.

 

[sammybee77]

Is it possible to write in two statements that are executed at the same time? Would you recommend SQL or PL/SQL?