Evaluate Consulting Services

Month: March 2021

Plug In: Number Field with Decimal

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:,,,,,,, APEX versions:,,  21.1.0 Installation: Go to GitHub and export plugin file “item_type_plugin_orclking_number_field.sql” from Source directory and import it into …

Plug In: Number Field with Decimal Read More »

Plug-In: APEX Google Pie Chart

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:,,,,,,,, APEX versions:  5.1.3,, …

Plug-In: APEX Google Pie Chart Read More »

Single Callback to Draw Multiple Google Charts in Oracle APEX

DECLARE l_title VARCHAR2(240) := ‘Breakdown of Top 10 Infected Countries’; l_chart_values VARCHAR2(4000); CURSOR cur_top10_countries IS SELECT country, total_cases   FROM (SELECT COUNTRY, TOTAL_CASES,         RANK() OVER (ORDER BY total_cases DESC) AS rank        FROM fxgn_global_data)  WHERE rank <= 10; BEGIN    htp.p(‘<html>’);   htp.p(‘<head>’);   htp.p(‘<script type=”text/javascript”  src=”https://www.gstatic.com/charts/loader.js”></script>’);   htp.p(‘<script type=”text/javascript”>’);   — Load Charts and the corechart and barchart packages.   htp.p(‘google.charts.load(”current”, {”packages”:[”corechart”]})’);   — Draw the pie chart and bar chart when Charts is loaded.   htp.p(‘google.charts.setOnLoadCallback(drawChart)’);   — Construct chart values   FOR i IN cur_top10_countries   LOOP     l_chart_values := l_chart_values || ‘[”’||i.country||”’,’||i.total_cases||‘],’;   END LOOP;     l_chart_values := substr(l_chart_values,1, length(l_chart_values)–1);   –dbms_output.put_line (l_chart_values); — draw chart   htp.p(‘function drawChart() {         var data = new google.visualization.DataTable();         data.addColumn(”string”, ”Country”);         data.addColumn(”number”, ”Total Cases”);         data.addRows([‘||l_chart_values||‘         ])’); — setup pie chart options   htp.p(‘var piechart_options = {title:”Piechart: ‘||l_title||”’,                                  width:500,                                  height:300}’);   htp.p(‘var piechart = new google.visualization.PieChart (document.getElementById(”piechart_div”))’);   htp.p(‘piechart.draw(data, piechart_options)’); — setup bar chart options   htp.p(‘var barchart_options = {title:”Barchart: ‘||l_title||”’,                                  width:500,                                  height:300,                                  legend: ”none”}’);   htp.p(‘var barchart = new google.visualization.BarChart (document.getElementById(”barchart_div”))’);   htp.p(‘barchart.draw(data, barchart_options)’); …

Single Callback to Draw Multiple Google Charts in Oracle APEX Read More »

Google Pie Charts in Oracle APEX

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 BY total_cases DESC) AS rank        FROM fxgn_global_data)  WHERE rank <= 10; BEGIN htp.print(‘<div id=”piechart” style=”width: 700px; height: 500px;”></div>’); htp.print(‘<script type=”text/javascript”  src=”https://www.gstatic.com/charts/loader.js”></script>’); htp.print(‘<script type=”text/javascript”>’); — Load google charts htp.print(‘google.charts.load(”current”, {”packages”:[”corechart”]})’); htp.print(‘google.charts.setOnLoadCallback(drawChart)’); — Construct chart values FOR i IN cur_top10_countries LOOP l_chart_values := l_chart_values || ‘[”’||i.country||”’,’||i.total_cases||‘],’; END LOOP; l_chart_values := substr(l_chart_values,1, length(l_chart_values)–1); –dbms_output.put_line (l_chart_values); — Draw the chart and set the chart values htp.print(‘function drawChart() {   var data = google.visualization.arrayToDataTable([   [”Task”, ”’||l_title||”’],   ‘||l_chart_values||‘ ])’); — Optional; add a title and set the width and height of the chart htp.print(‘var options = {”title”:”’||l_title||”’}’); — Display the chart inside the <div> element with id=”piechart” htp.print(‘var chart = new google.visualization.PieChart (document.getElementById(”piechart”))’); htp.print(‘chart.draw(data, options)’); htp.print(‘}’); htp.print(‘</script>’); END;