So for example, I have my table below to create CREATE TABLE "PC2"."TMP_PRODUCT" ( "ID" NUMBER(38,0) NOT NULL ENABLE, "ACCOUNTCODE" VARCHAR2(20 BYTE), "PRICESEGMENT" VARCHAR2(20 BYTE), "BRAND" VARCHAR2(20 BYTE), "PRODUCTLENGTH" NUMBER, "SALESID" NUMBER(38,0), CONSTRAINT "PK_TMP2_WPP_1009_ID" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255, CONSTRAINT "FK_TMP2_WPP_1009_SID" FOREIGN KEY ("SALESID") REFERENCES "PC2"."SALES" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE ); Then create a sequence which would manage the incremental part of the index key. CREATE SEQUENCE SEQ_TMP_PRODUCT START WITH 1 INCREMENT BY 1; Afterwards, create a trigger which what will do is to insert the incremented key of the table. CREATE OR REPLACE TR...