How to use primary key in Oracle Apex form, use primary key in multiple ways.

primary key in Oracle Apex, jaberit, jaberitbd, jaber, primary key, Oracle Apex, https://jaberitbd.blogspot.com/
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…

Post a Comment