How to use primary key in Oracle Apex form, use primary key in multiple ways.
How to use primary key in Oracle Apex form multiple ways. CREATE TABLE "STUDENT" ( "STUDENT_ID" NUMBER, "STUDENT_NAME" VARCHAR2(250), "ADDRESS" VARCHAR2(250), "PHONE" NUMBER, "DATE1" DATE, CONSTRAINT "STUDENT_CON" PRIMARY KEY ("STUDENT_ID") USING INDEX ENABLE ) / 1st ..................way Create a Dynamic Action >> Name- PRIMARY KEY Action >> Execute Server-side code >> SELECT NVL(MAX(STUDENT_ID),0)+1 INTO :P9_STUDENT_ID FROM STUDENT; Items to Return- P9_STUDENT_ID Client-side Condition >> Type >> Item is null. 2nd ..................way Create a Process >> Name- PRIMARY KEY PL/SQL Code >> BEGIN SELECT NVL(MAX(STUDENT_ID),0)+1 INTO :P9_STUDENT_ID FROM STUDENT; END; When Button Pressed >> Create. 3rd ..................way Create a Process >> Name- PRIMARY KEY PL/SQL Code >> declare function get_pk return varchar2 is begin DECLARE L_PRIMARY_KE…