We found Tables of Following along with Data. Created the Tables : CREATE TABLE "COUNTRY" ( "COUNTRY_ID" VARCHAR2(3), "COUNTRY_NAME" VARCHAR2(100), CONSTRAINT "PK_COUNTRY" PRIMARY KEY ("COUNT…
A bug in Oracle Apex Date : It shows like this : 2008 to 2028 You can control how many entries are in the selection list for the year selection, by setting in custom attributes the following: year-selection-range="100" like this :
While creating Barcode Reports, I developed 4 columns reports to show barcodes. Here is the process. 1 - 1st created the report normally with barcode. 2 - Then gone to page format 3 - Then changed the value of Columns : Output : Simple!
Steps for Windows: 1 - COPY jri-2.10.1-jasper-6.20.0.zip TO E:\apex_20.1 2 - UNZIP as jri-2.10.1-jasper-6.20.0.zip to jri-2.10.1-jasper-6.20.0 3 - Rename the folder jri-2.10.1-jasper-6.20.0 to JasperReportsIntegration 4 - Create a folder name jasper a…
You can open another page in Oracle Apex using JavaScript by calling the apex.navigation.redirect function. Here's an example: // Redirect to another page in Oracle Apex apex.navigation.redirect("f?p=&APP_ID.:2:&SESSION.::NO::P2_I…
To delete multiple values, we can use the amazing Row Selector type Item. we can use the following javascript and PLSQL : In the IG make any column as Row Selector. e.g. Create Dynamic Action like below. e.g. Add the following JavaScript code on true…
How To Create Desktop Based Application Through Google Chrome Browser : You might want to create desktop Apps by Oracle Apex. You have to create Shortcut with Window. Please go through the Steps outlined below with Screenshots: Step 1 : Go to three d…
How to Run Oracle 11g Report from Oracle Apex : Dynamic Action Javascript : var r_ip = "DESKTOP-B2K7G7D"; var r_port = "9002"; var r_url = "/reports/rwservlet"; var r_dept_id = $v("P2_DEPT"); var r_link…
Table Based Menu : To create menu based on table you have to create the following table : CREATE TABLE MENUTREE ( CODE VARCHAR2(10 BYTE), PARENT VARCHAR2(10 BYTE), TYP CHAR(1 BYTE), ----- TOP MENU,PARENT MENU, SUB MENU NAME VARCHAR2(50 BYTE), ACT…
Disallow Update or delete in Oracle Apex through Process : NB: CREATE PROCESS ON SAVE/"Apply Changes" Button: VAL_UPDATE_PERMISSION DECLARE V_USER_TYPE NUMBER(10); BEGIN SELECT USERTYP INTO V_USER_TYPE FROM APPSUSERS WHERE LTRIM(RTRIM(US…