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

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 <mvelikikh_at_gmail.com> 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 :
> https://www.thatjeffsmith.com/archive/2012/03/sql-developer-query-grid-tricks/
> Using HTML to Mark Up Your Data in Oracle SQL Developer :
> 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:
> 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 <post.ethan_at_gmail.com> 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
>> 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
>> _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".
>>
>

--
http://www.freelists.org/webpage/oracle-l