Posts

Plug-In: Tag Cloud Chart

Image
It's a Tag Cloud Chart Plug-In. A tag cloud, otherwise known as a word cloud or weighted list, is a visual representation of text data. This chart is typically used to show keyword metadata (tags) on websites, or to visualize free form text. Tags are usually single words, and the importance of each tag, which is often based on its frequency, is shown with font size or color. It makes the visualize of complex data easy and understand it at a glance.  This has been inspired by   anychart.com . 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 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "region_type_plugin_orclking_tag_cloud.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export a script  "Script to Populate Sample Data.sql"  from directory and compil

Plug-In: Heat Map Chart

Image
It's a Heat Map (or heatmap) Chart Plug-In. It's a visual representation of data where values are depicted by color. It makes the visualize of complex data easy and understand it at a glance.  This has been inspired by   anychart.com . 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 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "region_type_plugin_orclking_heat_map_chart.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export a script  "Script to Populate Sample Data.sql"  from directory and compile it in your schema. Step 2:  Create a new blank page. Step 3:  Export plugin file  "region_type_plugin_orclking_heat_map_chart.sql"  from  GitHub  source directory and import it into your application. Navigation: Shared Components ==> Plu

Plug In: Heat Map Report

Image
It's a Heat Map (or heatmap) Report Plug-In. It's a representation of data where values are depicted by color. It makes the visualize of complex data easy and understand it at a glance. This has been inspired by apex.oracle.com . Special thanks to Oracle APEX Product Development team, who brought this solution. 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 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file "region_type_plugin_orclking_heatmap_report.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1: Export a script "Script to Populate Sample Data.sql" from directory and compile it in your schema. Step 2: Create a new blank page. Step 3: Export plugin file "region_type_plugin_orclking_heatmap_report.sql" from GitHub source directory and i

Plug In: Number Field with Decimal

Image
It's a Number Field with Decimal Plugin In, which allow only Numeric Values and one DOT and Specified decimal value (2 or 4) in Number Field. 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 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file "item_type_plugin_orclking_number_field.sql" from Source directory and import it into your application. Steps to Achieve: Step 1:  Create a new blank page. Step 2:  Export plugin file  "item_type_plugin_orclking_number_field.sql"  from 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 3: Create a region to the page. Region type should be Static Content . Step 4:  Create a item to the region. Change item type to "

Plug-In: APEX Google Pie Chart

Image
This plug-in is used to render Google Pie Chart in Oracle APEX . This has been inspired by  Google Charts .  Google chart tools are powerful, simple to use, and free. We can try out Google's rich gallery of interactive charts and data tools. Plug-In Details: DB versions: 11.2.0.1, 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:   5.1.3, 18.1.0.00.45, 18.2.0.00.12, 19.1.0.00.15, 19.2.0.00.18, 20.1.0.00.13, 20.2.0.00.20,  21.1.0 GitHub Project Page | Download | Demo Installation: Go to GitHub  and export plugin file "region_type_plugin_orclking_google_piechart.sql" from Source directory and import it in your application. Steps to Achieve: Step 1: Create required objects (table, sequence, trigger) and populate sample data into a table. (As per your requirements) Step 2: Create a new blank page. Step 3: Export plugin file "region_type_plugin_orclking_google_piechart.sql" from Source directory and impor

Single Callback to Draw Multiple Google Charts in Oracle APEX

Image
Here, I am giving you an elegant way to draw multiple google charts in  Oracle APEX  using single callback method. This has been inspired by  Google Charts .  Google chart tools are powerful, simple to use, and free. We can try out Google's rich gallery of interactive charts and data tools. For example, suppose you want to draw multiple charts (Pie, Bar, Line and Donut) , showing top 10 covid-19 infected countries as on today. The following example shows how to display both charts side-by-side. If you want to draw multiple charts for the same data, it may be more convenient to write a single callback for both charts. Fig 1: Pie, Bar, Line & Donut Charts Step 1:  Create required objects  (table, sequence, trigger)  and populate sample data into a  table . (As per your requirements) Step 2:  Create a new blank page. Step 3:  Create a region to the page. Change region type to  PLSQL Dynamic Content. Drawing Multiple Charts using Single Callback: Copy and paste below PLSQL code int

Google Pie Charts in Oracle APEX

Image
Here, I am giving you an elegant way to build google pie chart in Oracle APEX . This has been inspired by Google Charts .  Google chart tools are powerful, simple to use, and free. We can try out Google's rich gallery of interactive charts and data tools. Step 1:  Create required objects  (table, sequence, trigger) and populate sample data into a  table . (As per your requirements) Step 2:  Create a new blank page. Step 3: Create a region to the page. Change region type to  PLSQL Dynamic Content. Making a 2D Pie Chart: Copy and paste below PLSQL code into the region's PLSQL code source. DECLARE l_task  VARCHAR2 ( 240 )  :=  'List out Top 10 Infected Countries' ; l_title  VARCHAR2 ( 240 )  :=  'Breakdown of Top 10 Infected Countries - 2D' ; l_chart_values  VARCHAR2 ( 4000 ); -- Getting Top 10 infected countries details CURSOR  cur_top10_countries  IS SELECT  country ,  total_cases    FROM   ( SELECT  COUNTRY ,  TOTAL_CASES ,          RANK ()   OVER   ( ORDER   B