Preview Button - View Print Dialogue in Oracle Apex

When building applications in Oracle APEX, you often want to let users print a specific region on the page — for example, a report or invoice — with just a click of a button. But sometimes, the print dialog opens in a new tab or window, disrupting the…

HIDE AND SHOW BUTTONS IN ORACLE APEX REGIONS

Oracle APEX makes it easy to build interactive web applications — even without being a full-time developer. One of the simplest yet most powerful features is controlling the visibility of buttons based on certain conditions. Let’s walk through how y…

Life Insurance MIS Reports

In this post I will describe some Reports that are frequently required by management and authority. The following reports are frequently required by the management and Authority:- ESSENTIAL REPORT(s) : 1 -  2nd, 3rd, 4th etc. lapse ratio by number pol…

Oracle Apex - Delete from Collection

In oracle Apex when you want to delete from a collection : Item Name : P101_DELETE_ID In Link add the code : javascript:getID(&SEQ_ID.) Link Text : <span class="fa fa-trash-o"></span> Add the function at "Function and G…

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