SQL Window keyboard shortcuts

[Lukasz Indeka]

I extensively use keyboard shortcuts. I'm not sure if that is possible in PL/SQL Developer and haven't found the corresponding options. If below options are not implemented, would it be possible to add following options to the list of available keyboard shortcuts?

1. Switching back and forth between query part and result set of the SQL Window.
2. Switching between tabs of the result set if there were more than one query called.
3. Copy as Expression List from the dropdown menu when some data is selected in the result set.

 

[fyzm7357]

1 and 2 should already be in the Key Configuration options under 'SQL Window: Switch between editor/results' and 'Window: Next Tab page/Window: Previous Tab page'. I am using v16.0.8.2176 of PL/SQL Developer.

I wasn't able to find anything for item 3.

 

[Lukasz Indeka]

Thanks for the 1 point! It is what I was looking for. But 2nd is for switching between windows not tabs of the result set.

 

[Marco Kalter]

The function of the Ctrl-H and Shift-Ctrl-H keys depends on the focus context. If the focus is on a result set, it will cycle to the next or previous result set tab. If the focus is on the editor, it will cycle through the SQL, Output and Statistics tabs.

I have added the function key for "Copy as Expression List" to the list of enhancement requests.

 

[Lukasz Indeka]

Hi,

I have one more request connected with the "Copy as Expression List" option. Please, add this (or similarly named) command to the context menu when only single record is selected. It would be especially helpful when varchar2 value has to be searched in given column. Example result:

text in ('brown fox jumps over the lazy dog')

OR

text = 'brown fox jumps over the lazy dog'

 

[Marco Kalter]

I tested this, and the "Copy as Expression List" option also works when only 1 cell is selected. If no cell is selected (e.g. when the text cursor is blinking in a cell), the "Copy as Expression List" option is not available. Is this the situation you are referring to?

 

[Lukasz Indeka]

Hi,

You're right. I selected all the text inside the cell, not the cell itself. My mistake.