Skip to Main Content

Oracle Application Express (APEX) Office Hours

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

Header container

August 23, 2018

14:00 UTC   Start Times Around the World

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: https://www.slideshare.net/secret/85bMlCoO3ts206

Session chat transcript = http://bit.ly/apex_office_hours_chat_20180823

Key Video Timestamps:
Question and Answer 51:30
Bookmark this link: https://asktom.oracle.com/pls/apex/asktom.search?oh=744

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

Session Resources

Experts

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, Senior Director, Software Development    
Joel is the Senior Director 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.

Sessions

All Sessions

Resources

Resources

Answers

Answers
Question
does ORDS support ibm http server as web server?
Answer

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

Answered by David Peake -
Question
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 https://bost.ocks.org/mike/nations/ ) 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
Answer

Ozren,

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

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

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 -
Question
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?
Answer

Hi Geert,

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

Answered by Hilary Farrell -