I have a problem generating the vertical lines in a line chart. E.g. take this query:
with nums as (
select rownum as rnum
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?