Convert Function from English to Bengali digits

Sometimes we may want to convert digits in English to Bengali or a Different Language. We might use the following function to convert -  CREATE OR REPLACE FUNCTION F_Bdigits(input_value IN NUMBER) RETURN VARCHAR2 IS  bengali_digits CONSTANT VARCHAR2(5…

How to Install Oracle Apex in Oracle Linux 8.8

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

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…

How to connect with AnyDesk?

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

Date Range Issues in Apex Date Item

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 :

Jasper Reports - Create 4 Columns Report

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!

How to Integrate Jasper Studio Report with Oracle Apex

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…

Load More
That is All