Evaluate Consulting Services

Blogs

Awarded Member of the Month (June) by Oracle APEX Community

Here I am giving an example to find where specific table or view is used in oracle database Query 1: All objects where specific table or view accessible to the current user is used in Oracle database. SELECT  referenced_owner        ||  ‘.’        || referenced_name  AS  table_name ,        referenced_type     AS   TYPE ,         owner        ||  ‘.’        ||  …

Awarded Member of the Month (June) by Oracle APEX Community Read More »

My technical blog is listed in Top 100 Oracle Blogs And Websites To Follow in 2021

Here I am giving an example to find where specific table or view is used in oracle database Query 1: All objects where specific table or view accessible to the current user is used in Oracle database. SELECT  referenced_owner        ||  ‘.’        || referenced_name  AS  table_name ,        referenced_type     AS   TYPE ,         owner        ||  ‘.’        ||  …

My technical blog is listed in Top 100 Oracle Blogs And Websites To Follow in 2021 Read More »

Plug In: Slideshow

A slideshow is used to cycle through elements. A plugin to display images as a responsive slideshow (Display an automatic or manual slideshow). Credits 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 Installation: Go to GitHub and export plugin file “region_type_plugin_orclking_slideshow.sql” from Source directory and import it into your application. …

Plug In: Slideshow Read More »

Plug-In: Heat Map Chart

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 Installation: Go …

Plug-In: Heat Map Chart Read More »

Plug In: Heat Map Report

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, …

Plug In: Heat Map Report Read More »

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: 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 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: 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, …

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;