sql - Oracle - Insert New Row with Auto Incremental ID

PHOTO EMBED

Wed Jun 22 2022 09:41:31 GMT+0000 (UTC)

Saved by @statu7 #sql

insert into WORKQUEUE (ID, facilitycode, workaction, description)
  values ((select max(ID)+1 from WORKQUEUE), 'J', 'II', 'TESTVALUES')
content_copyCOPY

https://stackoverflow.com/questions/8717675/oracle-insert-new-row-with-auto-incremental-id