Editor enhancement request

[mike]

First - Thanks for the incredible editor! The beautifier alone has saved me tons of time and there are lots of other incredible things that help me every single day.

One feature that I thought would be nice is if I double click on a word, all occurrences of that word could be highlighted. Kind of like a quick search.

Take this for example:

SELECT a.first
      ,a.second
      ,b.first
      ,b.second
FROM   table1 a
      ,table2 b
WHERE  a.id = b.id;

If I double click on the "a" table alias, it would be helpful if all other "a" words get highlighted. Some SQL statements are soooo long and any help adds some relief.

 

[mike]

I monkeyed around. "Search all" does this, so that's nice. It looks like I cannot delete a post though. It would still be slightly quicker if the double click did it. Have a good day!

 

[Starina]

You can assign hotkeys for "Search All" command, rrProject plugin include this feature.

Use this tool:
Code Editor Wizard --> Text Highlight Tool.

The plugin also includes many other features.

 

[mike]

Thank-you. I installed the plugin and found the tool. It is enabled. I have no idea how to use it. I see keyboard shortcuts for rrProject and assigned one. Nothing happens when I press the shortcut.

It seems like a nice plug-in. Do you know what I'm doing wrong?

 

[Starina]

Text Highlight Tool adds menu command "Edit \ Selection \ Text Highlight". You can assign shortcut for this menu command (use "Tools \ Preferences \ Key Configuration").

Select the text in the editor, press shortcut after that text will be highlighting.

Good luck.

 

[mike]

Thanks for the reply. It doesn't add the menu command though. At least for me.

Monkeying around, I found that if I disable the plug-in, restart PL/SQL Developer, enable the plug-in. Then There are entries for rrProject in the Key Configuration preference. If I assign a shortcut key, it doesn't work. Next time I open the preferences, there are no longer entries for the plug-in, nor for edit/selection/text highlight.

I did find that I can customize the toolbars if I go through the disable/restart/enable routine, so that a Text Highlight button shows up. That one seems to stick, so I can live with that.

One addition that would make it more useful is to have it search whole words only. For example, if I have a table synonym of "pg" and another "pgrf", the "pg" lights up in the "pgrf" even though I have the "Whole words only" selected in the normal search.

Thanks for the plug-in!
Mike

 

[olona]

Yeah - that's the way it works in TOAD and IntelliJ. Very helpful, to quickly highlight THTA word.

It shouldn't even be a shortcut to it, should be like that by default. Highligh one object like a alias, column or method name.

 

[mike]

Yes. Notepad++ works that way too. I sometimes copy things back and forth between Notepad++ and PL/SQL Developer, just for the editor functions of Notepad++, so I thought I might as well ask.