Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLDEV:GAUGE Doesn't work as expected...

KiwiAndrewSep 15 2014 — edited Sep 15 2014

Or at least, not as I expected

The following query:

select level*10, 'SQLDEV:GAUGE:0:100:10:20:' || (level*10) progress

from dual connect by level <= 10;

produces the following output:

SqlDevScreenshot01.png

The first 6 rows are at least consistent with the parameters.

The next 3 the final segment has change to yellow (not orange); the last row the last segment is red.

The colour change occurs at ~67% or 90% respectively.

What I expected is that the last segment wouldn't change colour

If the colour is going to change, I'd rather it actually reflected the band the value is in, and it should be the whole gauge, not just the last segment - this way the colour of the gauge would indicate a problem (i.e. process < 10% complete = red, >75% = green), and the segments need not be shown....

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2014
Added on Sep 15 2014
2 comments
1,260 views