Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

Trick: Getting Rid of SQLcl Buffer Line Numbers When Pasting into SQLDev

1 Min Read

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.

Author

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

Related Posts

4 Comments

  2. Peter Nagel Reply

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

  3. 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