Yeah you can do it today, for a CELL, easily with a CASE…I’m not sure about the
entire ROW though
From: Mikhail Velikikh <mvelikikh@xxxxxxxxx>
Sent: Friday, December 13, 2019 11:19 AM
To: post.ethan@xxxxxxxxx
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: SQL Dev Feature Request - Smart SQL (define row colors within
result sets).
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 : HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__www.thatjeffsmith.com_archive_2012_03_sql-2Ddeveloper-2Dquery-2Dgrid-2Dtricks_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=EHTrM2SPiRW6b8A9BMZTzNnH2iWhSb2pSDlZvh13Rkc&s=i4DP5pYswrnzse2jsWOvaCc2JAnCho4ssR20lQT89-o&e="https://www.thatjeffsmith.com/archive/2012/03/sql-developer-query-grid-tricks/
Using HTML to Mark Up Your Data in Oracle SQL Developer : HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__www.thatjeffsmith.com_archive_2012_07_using-2Dhtml-2Dto-2Dmark-2Dup-2Dyour-2Ddata-2Din-2Doracle-2Dsql-2Ddeveloper_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=EHTrM2SPiRW6b8A9BMZTzNnH2iWhSb2pSDlZvh13Rkc&s=WDtNagoBBjZr8pwgOBCYYQrgM6SsbZOEVtZHlhDd8fA&e="https://www.thatjeffsmith.com/archive/2012/07/using-html-to-mark-up-your-data-in-oracle-sql-developer/
I use ANSI escape codes in the terminal (mine is Alacritty: HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_jwilm_alacritty&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=EHTrM2SPiRW6b8A9BMZTzNnH2iWhSb2pSDlZvh13Rkc&s=Sa7W7sLMWM3pCh_Ix_6_xqumzmTbUM6hL7O4WzNpMcc&e="https://github.com/jwilm/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 <HYPERLINK
"mailto:post.ethan@xxxxxxxxx"post.ethan@xxxxxxxxx> 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 HYPERLINK
"https://urldefense.proofpoint.com/v2/url?u=https-3A__gitlab.com_post.ethan_arcsql&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=EHTrM2SPiRW6b8A9BMZTzNnH2iWhSb2pSDlZvh13Rkc&s=wfxhMP-UwIQ2qN1P3dvlSyYv0lzEFEqk_zc0yadKzJs&e="https://gitlab.com/post.ethan/arcsql
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
@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".
