How bad is it to mimic IDENTITY / AUTOINCREMENT columns using triggers in Oracle?

Question

I support an application that was originally written as specific to SQL Server (using IDENTITY fields). Thus, we had to define many triggers for the primary keys of auto increment tables.

I was told that this is considered a hacker workaround in the Oracle world, but they told me about each other. How big is the deal — using triggers to increment primary keys from a sequence, rather than directly using that sequence?

Answer 1

, . , (, PL/SQL API), INSERT - . , !

Answer 2

, " " , Merge. Merge, , , .