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: Select LOV Item and set Initialization JavaScript Function : //Javascript Codes function(options) { var columns = options.columns; // set minimum width for the LOV dialog options.minWidth = 600 ; // TRIP_ID if (columns.T…