CRUD Operation in Oracle Integration Cloud

In the series of blog, we’ll implement the REST services which will show the CRUD operation on the Oracle database table (USER_MASTER)

CREATE TABLE “USER_MASTER”

(“ID” NUMBER(20,0) NOT NULL ENABLE, “FIRST_NAME” VARCHAR2(200 BYTE), “LAST_NAME” VARCHAR2(200 BYTE), “DESIGNATION” VARCHAR2(200 BYTE), “QUALIFICATION” VARCHAR2(200 BYTE),               CONSTRAINT “USER_MASTER_PK” PRIMARY KEY (“ID”) );

CREATE SEQUENCE “USERS_SEQ”  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE ;

CREATE OR REPLACE TRIGGER USERS_TRG

BEFORE INSERT ON USERS

FOR EACH ROW

BEGIN

  <<COLUMN_SEQUENCES>>

  BEGIN

    IF INSERTING AND :NEW.ID IS NULL THEN

      SELECT USERS_SEQ.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;

    END IF;

  END COLUMN_SEQUENCES;

END;

ALTER TRIGGER “HR”.”USER_MASTER_TRG” ENABLE;