Noor Bappy - Oracle Specialist | Apex Expert

ORACLE DATABASE 19C ON OEL8.8    [root@apex]# hostname apex.testdb.com [root@apex]# su oracle  [oracle@apex ~]$ cd /home/oracle/ [oracle@apex ~]$ mkdir -p soft [oracle@apex ~]$ cd soft/ [oracle@apex soft]$ ls -lrt total 0 [oracle@apex soft]$ pwd /home…

HTML Report with Image when Print : CREATE TABLE "IMAGES"     ( "IMAGE_ID" NUMBER(10,0),  "NAME" VARCHAR2(100),  "MOBILE_NUMBER" VARCHAR2(100),  "ADDRESS" VARCHAR2(100),  "IMAGE_DATA&qu…

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…

https://drive.google.com/file/d/1MaW__lwKVZGp6obxVZIptMKgkED9Z1r4/view?usp=sharing https://drive.google.com/file/d/1MaW__lwKVZGp6obxVZIptMKgkED9Z1r4/view?usp=sharing

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…

java.awt.Image

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…