Oracle APEX Blogs - Jaydip Bosamiya - Oracle APEX Consultant

Oracle JET Charts  is a beautiful chart library which has out-of-box support in Oracle APEX version 5 on-wards. Purpose of this blog is to introduce with a small tweak in Series Bar Chart. Problem When you use Series Bar Chart and if you have some series with NULL or ZERO value, the bar will not appear at all. This is correct behavior from the Charting way, but visually - you may find it difficult to detect the bar against a series. Below is a sample bar chart with ZERO values where you can see gaps between. Below is same bar chart but fixed the gap with very small bar where the value is ZERO. Solution Inside your series bar chart, you will find Axes, and select "Y" Change following options: Format = "Decimal" Decimal Places = 0 Step = 1 Working Demo Hope this helps! Regards, Jaydip Bosamiya jbosamiya@gmail.com

I came across a very strange issue with my SQL Developer. The connection bar is not opening/expanding/minimizing/maximizing. So, I was scared thinking that I have re-setup my SQL Developer. But, when I did a quick google search, I found that following steps should solved such issues: Go to Windows menu Click Reset Windows To Factory Settings It will take some time and your SQL Developer gets restarted with all your windows resettled. You should be able to get your connection bar back. Hope this helps! Regards, Jaydip Bosamiya jbosamiya@gmail.com

I have came across following URL - which shows how simply you can create jQuery Circular Progress Bar. https://webdevtrick.com/circular-progress-bar-css/ Based on provided information on above link, I have tried to implement same in Oracle APEX - Classic Report. I am sure we can integrate same in Interactive Report, List Regions or Regions with Dynamic PL/SQL. Following are the steps to build Pie chart kind information to show how many percentage of employees belongs to each of the department. 1. Create new classic report region with following query. select deptno, dname, loc, round((emp_cnt/emp_tot),2) circular_val from( select DEPTNO,        DNAME,        LOC,        (select count(1) from emp e where e.deptno = d.deptno) emp_cnt,        (select count(1) from emp) emp_tot   from DEPT d) 2. Now, change circular_val column and add following HTML code in HTM...