I love SQLcl – I use it more and more every day.

But.

Sometimes I need a GUI.

Copying and pasting code between the two can be cumbersome –

line numbers and current line indicator - make my query no go
line numbers and current line indicator – make my query no go

Toggle the Block Cursor

Available in v4.1 with Ctrl+Click, but this is easier metinks in v4.2
Available in v4.1 with Ctrl+Click, but this is easier metinks in v4.2

You can do this in v4.1 with the mouse and clicking to set the cursor points. In v4.2 you can do it by toggling the block cursor mode, and then it’s all keyboard from there. I have a standing ER to be able to keyboard/toggle the cursor mode so you can avoid the mouse completely.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

4 Comments

  1. Peter Nagel Reply

    oh, my keyboard syntax has been interpreted as a tag… (and stripped, i think). I wrote about pressing the Alt key…

  2. Peter Nagel Reply

    Did you ever had a look at Notepad++ and how this ist handled there? Simply pressing while marking the block – and this is true for mouse and keyboard. Great solution IMHO 😉

Write A Comment