Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle SQL Developer - How to Display Percents using Color (Not Numbers)

While working out of Oracle SQL Developer I came across a feature that I was unaware of until today. The feature is to display Percentages using colors not unlike how a horizontal bar chart could display the same percentages. I found it by right clicking on the connection and choosing the option 'Manage Database'.

Is this feature available for ANY query/report where percentages are being displayed? The column I'm referring to in the screenshot is the 'Percent_Used' column.

enter image description here

like image 496
Code Novice Avatar asked Nov 18 '25 09:11

Code Novice


1 Answers

And here’s the code:

SELECT
    'SQLDEV:GAUGE:0:20000:1000:5000:' || peeps.salary "WhatIsItYoudSayYouDoHere",
    peeps.salary,
    peeps.first_name
    || ' '
    || peeps.last_name,
    peeps.job_id
FROM
    hr.employees peeps;

SQLDEV:GAUGE:0:200:50:150 equates to min:max:low threshold:upper threshold:value to graph

enter image description here

like image 74
thatjeffsmith Avatar answered Nov 20 '25 09:11

thatjeffsmith



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!