Re: SQL Dev Feature Request - Smart SQL (define row colors within result sets).

From: kris rice <>
Date: Fri, 13 Dec 2019 18:58:10 -0500
Message-ID: <>

We see everything:-). I use vi and vscode a ton but honestly we’re looking how to add this these new features into the web version of sqldev.


On Fri, Dec 13, 2019 at 11:51 Ethan Post <> wrote:

> Holy smokes, that first link is cool (only one I looked at so far). One of
> the issues I am having with SQL Developer is discovering all of the
> features that are already there. Side note, I find I have been doing
> development with the same file using Sublime and SQL Developer. I love that
> the file updates automatically in both programs (usually). The
> auto-complete (using any open file), themes, and sidebar histogram are the
> features that keep me in both places for the time being. When I need to
> compile and debug I am in SD. Hopefully the SD team are taking a look at
> Sublime features. I know the number of features that "can" be added never
> ends.
> Thanks!
> On Fri, Dec 13, 2019 at 10:19 AM Mikhail Velikikh <>
> wrote:
>> Hi Ethan,
>> Posting here for comment/debate and the solutions you are using
>> I know it is possible to highlight columns using custom HTML and displays
>> gauges in the Grid as Jeff Smith blogged about:
>> SQL Developer Query & Grid Tricks :
>> Using HTML to Mark Up Your Data in Oracle SQL Developer :
>> I use ANSI escape codes in the terminal (mine is Alacritty:
>> ) to highlight SQLPROMPT in SQL*Plus
>> whether I connected as SYS-something (SYSDBA, SYSBACKUP, etc.) or as a
>> normal user.
>> On Fri, 13 Dec 2019 at 15:36, Ethan Post <> wrote:
>>> I opened a feature request for SQL Developer. Posting here for
>>> comment/debate and the solutions you are using. Once I figure out how to
>>> actually link to the feature request and you can vote if you like.
>>> One of the reasons I submitted is a query I am writing for
>>> which I would like to run in SQL
>>> Developer with F9 not F5 (script) and render the grid with certain lines in
>>> certain colors easily. I will be pushing out some cool updates to ArcSQL
>>> later today.
>>> Thanks,
>>> Ethan
>>> _at_poststop
>>> This is "nice to have" feature. I would like the ability to define
>>> colors (and perhaps other attributes) for certain lines and columns in SQL
>>> Developer using the returned data itself. A very rudimentary implementation
>>> would be a special column which contains #XXXXXX color hash. As long as I
>>> tell SQL Developer that column "foo" is a column containing certain
>>> instructions the line would be rendered using the color defined in the
>>> column.
>>> My use case is a result set that contains three rows for each entity I
>>> am interested in. I need to look at certain lines across entities.
>>> Returning log file type data would also be a use case. It would make it
>>> very easy to spot the lines we are interested in within the greater context
>>> of the result set.
>>> Thanks for considering. I know there are ways to do this with HTML but
>>> that in my opinion is too much work and ugly. I want to see SQL Developer
>>> become the only tool I need and I want to be able to share solutions easily
>>> with others that are pure SQL, work even if the color capability is not
>>> present, and have enhanced power if run within SQL Developer. Maybe we can
>>> call it "Smart SQL".

Received on Sat Dec 14 2019 - 00:58:10 CET

Original text of this message