This drove me nuts for a few minutes, so I figure you might need help too. That probably explains why you had to Google ‘Block Select’ and wound up here.
Here is what you want:
Block selection, works with the keyboard and mouse in SQL Developer
There’s No Trick, But You Do Have to Enable It
The default behavior is to do a normal ‘wrapping’ selection of text. You can disable this under the Edit menu.
By default your selections will ‘wrap’
Selecting Text In Action
Now you see it, now you don’t!
Twitter
RSS
GooglePlus
Facebook
Jul 24, 2012 @ 01:59:26
Nice! Did you know you could do this in PuTTY too? Just hold the ALT key before clicking
Jul 25, 2012 @ 00:08:19
On a related note, if I have three SQL’s in a window (like as per your example), do you know if there is any way of running just one of them … without … having to highlight it ?
Its fine when the SQL’s are 1 line long, but when they get very long … its a pain.
Cheers
Connor
Jul 25, 2012 @ 05:02:58
Place your cursor in the statement and hit ctrl enter, making sure to use delimiters like a semicolon.
Jul 31, 2012 @ 01:05:20
Hi Jeff,
I came to your site after searching for ‘line wrap in sql developer’ on google but appraently the article is on the ‘wrap selection’ which atleast help me to figure that ‘wrap selection’ is not what I am looking for.
Basically what I want is fairly simple but somehow I am not able to turn it on.
What I am trying to do is that when the query in the sql developer goes beyond the visual area then instead of generating a horizontal scrollbar, it should simply wrap the line to next line.
Now I thought that this should be possible through some option in “tool->prefrences->code editor” but apparently it is not there. I did a little bit of googling but couldn’t find anything. Any thoughts?
Jul 31, 2012 @ 08:56:07
I will answer your question in today’s blog post
Short answer: ‘Mostly’