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 Next, you can either click and drag the 2nd worksheet tab to the right or underneath. If you drag [...]
worksheet
SQL Developer Quick Tip – Pin Query Result Sets and Plans
It’s very rare that a query is developed in a single take. You start with a framework, and then trim down to the essential elements. Then you start working about sort orders, performance, and formatting. As you develop your SQL, you may want to keep several iterations of the data and their plans available. SQL [...]
Twitter
RSS
GooglePlus
Facebook