SQL Developer Quick Hit: Split and Side-by-Side Editors

thatjeffsmith Database Stuff, SQL Developer 6 Comments

Tell Others About This Story:

Want multiple scratch pads for your queries? Have a hundred+ line stored procedure? Then here are two tips for you!

Side-by-Side Worksheets
To get started you’ll need at least two worksheets open. So something like this

This is annoying!

Next, you can either click and drag the 2nd worksheet tab to the right or underneath. If you drag right you will get something like this –

This is divine!

If you’re having problems getting the panel to drop just as you want it to, you can cheat. Right-mouse-click on the worksheet panel label and choose ‘New Editor Tab Group.’

Split editor PL/SQL Editor
This is very similar. Instead of having 2 independent editors, we have one block of text available from two different editor panels. So if you have the proverbial 1,000 line Trigger, you can keep one editor panel set to the top where all of your declarative code is, and another down where you are working on the ‘bug.’ To ‘split’ the editor, you need to find the little horizontal bar above where the scroll area is and drag it down. So looks a little something like this:

PL/SQL Editor, Do a Split!

If you drag correctly, you should get something like this

2 Editors, One Object

Bonus Tip! Preview text in the scroll bar before you scroll!

Scroll bars are nice, but wouldn’t it be even nicer if you could tell where you were going to land before you went there? If you hold down Ctrl and mouse down in the scroll bar, you can see the text for that area before scrolling to that part of the editor. This works both in the Worksheet and the PL/SQL editors.

Preview the text at different scroll bar areas

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 6

  1. Trying the last tip “Ctrl + Mouse Down” in 4.1… it just appears to move the scroll position (like a normal click)

    Leaves a little “line” in the gutter which I can then hover on, but by that stage I’ve already navigated to that area.

    Am I doing something wrong ?

    Cheers,
    Connor

    1. thatjeffsmith Post
      Author
      1. Actually the feature is there ( in 3.2.20.09 at least ) but not in the actual scrollbar – on the gutter just to the side of the scrollbar. Also it’s ctrl + mouseover (no mousedown or drag – just move the mouse)

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *