Skip to main content

Posts

Showing posts from November, 2021

Received the Oracle APEX Challenge Coin

What is Challenge Coin? A challenge coin is a small coin or medallion, bearing an organization's insignia or emblem and carried by the organization's members. Traditionally, they might be given to prove membership when challenged and to enhance morale. What is Oracle APEX Challenge Coin? It is a challenge coin which will be sponsored by an Oracle apex community member who appreciates your contribution in this community. In November 2021,  I received the Oracle APEX Challenge Coin for my significant contributions to the Oracle APEX community. Hard work Pays off!!!  Adrian Png tweeted this, Congratulations @tkarkuvelraja ! @sridharSunila has sponsored you an APEX Challenge Coin. It's in the mailbag and heading your way. Congratulations again and thank you for all your contributions to the community! #orclapex #challengecoin pic.twitter.com/28nUqNupa6 — Adrian Png 🧡🕯️ (@fuzziebrain) November 12, 2021 Here's my tweet: Thanks for honoring me with the APEX Ch

Generating the report with APEX_DATA_EXPORT

With the APEX_DATA_EXPORT package, you are able to export data from Oracle Application Express in the following file types: PDF, XLSX, HTML, CSV, XML, and JSON. Step 1: Create a table and populate it with some sample records. CREATE TABLE emp   (     empno        NUMBER,     first_name   VARCHAR2(240),     last_name    VARCHAR2(240),     mgr          NUMBER,     deptno       NUMBER,     sal          NUMBER,     created_date TIMESTAMP (6),     comm         NUMBER,     hiredate     DATE,     JOB          VARCHAR2(240),     ename        VARCHAR2(240),     PRIMARY KEY (empno) USING INDEX ENABLE   ); /    INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (1, 'Larry', 'Ellison', ,                  10, 5000, LOCALTIMESTAMP);   INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (2, 'Juan', 'Juan', 1,  

Plug In: Image Zoom

A plug in to enlarge a image using lens or mirror (glass). Credits goes to   w3schools . Plug-In Details: DB versions:  12.1.0.1, 12.2.0.1, 18.4.0.0, 19.0.0.0.0, 19.2.0.0.19, 21.0.0.0.0, 21.1.0.0.0, 21.1.0.0.1 APEX versions:  20.1.0.00.13, 20.2.0.00.20,  21.1.0 and above GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "item_type_plugin_orclking_image_zoom.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export plugin file  "item_type_plugin_orclking_image_zoom.sql"   from  GitHub  source directory and import it into your application. Navigation: Shared Components ==> Plug-ins ==> Import Plugin will be listed under plug-ins bucket after successful installation. Step 2:  Create a new blank page. Step 3:  Create a new region to the page. Step 4:  Create a item to the region and change the item type to  Image Zoom [Plug-In] . Note:  You can define image URL using page item or