Want multiple scratch pads for your queries? Have a hundred+ line stored procedure? Then here are two tips for you!
To get started you’ll need at least two worksheets open. So something like this
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 -
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:
If you drag correctly, you should get something like this
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.