Did you know you can build a gauge into a report or a data grid query in SQL Developer 1.5? Take a look at this quick demo. Below is a preview screen shot.

This blog is mostly about Oracle development tools; the early posts are about Oracle SQL Developer and SQL Developer Data Modeler written as product manager for these products. There are also the occasional forays into travel, conferences and a few mentions of the Delhi missions done. In 2011 I left Oracle, spent a few more years in IT and then switched completely. I’m now a full time picture framer. The blog remains, with no updates, in case there is still something of interest here.
6 comments:
Hi !
Is there a place where you can see what SQL DEV extras you can specify in the SELECT statement (csv, seldev:gague, etc)?
best regards
Mette
We don't have a specific list.I'll see if we can sort out something like that. There are very few as most of the commands are just SQL, SQL*Plus and PL/SQL commands in the worksheet, as you'd expect in SQL*Plus.
Sue
Would be nice with a list, since most of us dont use sql*plus anymore, but toad or toad look alikes - and of course SQL Developer :-)
Thanks
Mette
Is it possible to control the colours used for the sections of a guage provided by SQLDEV:GUAGE:min:max:low:hi - I really would like to be able to create a graduated scale from light blue (frosty) to amber progressing through to red.
No chance we can specify low color:med color:high color parameter details ?
Hi Sue, first of all congratulations for your blog. It is very helpful.
The gauges are great but how can I show them to my boss or to my customer ?
I tried to export as HTML but SQLDev assembles just SQLDEV:GAUGE string instead of the graphic.
Do you suggest any tip or tool to do that?
Josir Gomes
Josir,
The Gauge is just that, a SQL String. We don't provide more functionality for these at this stage.
Why not have SQL Dev on a memory stick and take that to your customer? That way you can show more than just the gauge. Lots of our consultants use SQL Developer on a stick and don't worry with installing it on the machine.
Sue
Post a Comment