Skip to Main Content

APEX Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

August 23

14:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Data Visualization with Oracle APEX
In this session targeted at beginners, APEX Product Development team member Hilary Farrell shows the easy and impressive data visualizations possible in APEX 18.1.

Slides available at:

Session chat transcript =

Key Video Timestamps:
Question and Answer 51:30

Your Experts

Hilary Farrell
Hilary Farrell, Consulting Member of Technical Staff
Hilary Farrell is a Consulting Member of Technical Staff on the Oracle Application Express Development team, and is responsible for the charting integrations using Oracle JET Data Visualizations, and various other core features and functionality in APEX.
Joel Kallman
Joel Kallman, Vice President of Software Development    
Joel is the Vice President of Software Development at Oracle America, Inc., managing the development and product management of Application Express (APEX). He started working with Oracle Database in 1992 and joined Oracle in 1996. Joel's passion is to make customers extraordinarily successful with the Oracle Database, SQL and Oracle Application Express (APEX). He is a proud alumnus of The Ohio State University, College of Engineering, with a Bachelor's degree in Computer Engineering.
David Peake
David Peake, Senior Principal Product Manager - Application Express    
David joined Oracle in 1993. He spent the first 13 years within Oracle Consulting in Australia, New Zealand, and the United States. In 2006, he joined the Product Development team as the Oracle Application Express (APEX) Product Manager. He presents at many conferences around the world including Oracle Openworld, ODTUG KScope, OGh APEX World, DOAG and UKOUG.


does ORDS support ibm http server as web server?

No ORDS can only be installed into Oracle WebLogic Server, Apache Tomcat, Oracle GlassFish, or st Show more.

Answered by David Peake -
Hi, can you please explain what is the architectural reason for such a difference between charts in IR, IG and chart regions. For example UI, series ( it can be specified in IG chart and not in IR chart ), type of charts ( in IR we have only 4 charts to choose ). Is there any plan to make it more standardized? If they all use JET charts, is it possible to put JET chart properites to APEX? Is it possible that we get motion charts in APEX? ( example ) Integration of Oracle DataVisualization Desktop into APEX? I use carts for visualization of data in my every day work. Thank you, I wish you and your team success. Ozren Pestic Croatia


With APEX 18.1 we introduced JET Charts into IRs. As such the charts in IRs and Show more.

Answered by David Peake -
Hi, Just wanted to check if there will there a recording of this available ?

Yes - All of the Office Hours sessions are recorded and then made public within a few days at mos Show more.

Answered by David Peake -
I have a problem generating the vertical lines in a line chart. E.g. take this query: with nums as ( select rownum as rnum from dual connect by rownum < 300) select rnum/9 as x, sin(2*rnum/30) as y from nums In the X-Axis, my tick markers, have decimal values. I would like to have vertical lines on x-Axis values 1,2,3,4 etc, or maybe 2,4,6,8,... I don't manage to get control over this, they always come at .1111111 .666666 1.222222 etc... no matter what I specify in the graph settings. How to specify exactly the interval for the markers on the X-Axis?

Hi Geert,

Thank you for taking the time to post your chart question, and I hope you fou Show more.

Answered by Hilary Farrell -