Study With Rafiq

Step 1 : CREATE TABLE ORDER_INFO ( ID                           NUMBER, ORDER_NO              VARCHAR2 (25), ORDER_STATUS       NUMBER, ORDER_DATE           DATE, CUSTOMER              VARCHAR2 (25), C_PHONE                VARCHAR2 (25), CONFIRM_STAT…

Step 1 : Create Interactive Grid Region Select Page and go to Inline : copy to paste # GRID .a-GV-cell {     height: 30px; } .wrap-cell {     max-height: 134px;     white-space: normal;     overflow: hidden; } .a-GV-table td, .a-GV-table th {   ov…

Create Dynamic Action on   "P99_2ND_DAY" & "P99_3RD_DAY" item Action : Set Value Set Type : PL/SQL  Function Body if :P99_3RD_DAY is null then  return to_date(:P99_2ND_DAY,'DD-MM-RR') - to_date(:P99_1ST_DAY,'DD…

STEP 1 : Modal Dialog page (151 & 152) for status update STEP 2 : Create Interactive Report  and SQL Query With HTML & CSS SELECT  D.CREATE_DATE,  get_AIRBILL_NUMBER(D.ID) MAWB_NUMBER, D.FLIGHT_NUMBER_1||' - '|| D.FLIGHT_DATE_1 First…

Step 1 : Create Region Interative Report SQL Query : select       APEX_ITEM.CHECKBOX(1,EMPNO,'UNCHECKED') selected,           EMPNO,        ENAME,        JOB,        MGR,        HIREDATE,        SAL,        COMM,       decode( APPROVE_STUTA…

Step 1 :  Create Apex Item Type : Radio Group Item Name : P125_APPROVED_STUTAS Static Value : SQL Query :

Step - 1 : Select InteractiveGrid Region And Go to Static ID  Static ID : GRID Step - 2 : Create Page Load Dynamic Action  Action Name : GRID Action : Execute JavaScript Code  Code : apex.region(" GRID ").call("getActions").set(&…