Posts

Showing posts from March, 2021

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