Skip to content
Advertisement

How to set an autoincrement composite primary key in oracle19c?

I want to create a table, with composite primary key and autoincrement, in Oracle 19c, like this:

How I do it?

Advertisement

Answer

Create trigger on this table to achieve this result. Assume table name is test123

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement