Showing posts from October, 2023
Setp-1 : ======= Create Interactive Report SQL Query : For Check Box APEX_ITEM.CHECKBOX(1,ID,'UNCHECKED') SELECTED Setp-2 : ====== Processes : VASSEL_APPROVAL Declare v_count number:= 0; v_appCont number ; begin FOR i in 1…
Step : 1 ====== CREATE TABLE AUTO_NUMBER_GENERATE ( ID NUMBER , TYPE VARCHAR2(25 CHAR) NOT NULL ENABLE, AUTO_NUMBER NUMBER, PREFIX VARCHAR2(25 CHAR), CREATE_BY …
================ Package Specification ======================= Create or Replace Package OVERLOADING_PACKAGE AS PROCEDURE DISPLAY_Result (p_lower IN NUMBER, p_upper IN NUMBER); PROCEDURE DISPLAY_Result ( V1 IN NUMBER, V2 IN NUMBER, V3 IN NU…
Step 1 : Create LOV & Call to Item Step 2 : Create Ajax Callback Name : EMP_LOV PL/SQL CODE : DECLARE V_FIRST_NAME VARCHAR2 (250); V_LAST_NAME VARCHAR2 (50); V_SALARY Number(10); CURSOR cur_c IS SELECT LAST_NAM…
Step 1 : --> Create List of Value ( SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES ) --> Call Popup LOV (FIRST_NAME) --> Display As : Modal Dialog Step 2 : Set STATIC ID LAST_NAME = LAST_NAME SALARY = SALARY (Same Name…
