Here is a 2 second tweak that I recommend for all users of Oracle SQL Developer. Open Tools – Preferences Database – Worksheet – ‘Grid in checkerboard or Zebra pattern’ – toggle ON Now run a query in the worksheet or open a table in the browser If you’re going to be staring at data for hours on end, give your eyes a break and mix it up a bit!
Can you tell us more about the debugger? Can you show us the debugger? What about the debugger? Can you spell ‘debugger’? Why can’t the debugger show X? What is COMPILE WITH DEBUG anyway? Debugger? Skip to Episode V – Starting the Debugger In the past 10 years I have probably heard these questions and countless variations more than any other when it comes to the topic of PL/SQL interactive development environments (IDE.) Debugging seems…
Most third generation language (3GL) IDEs have trained hackers like me to expect the tool to write some of the code for them. Regular internet folks are already used to having search terms and URLs auto-completed in their browsers. I don’t want to get into a debate over whether this makes us lazier AND dumber, but I DO want to give you a quick overview of what SQL Developer can do in this area. If…
Updated 9/28/2018 Writing Code is for Suckers Yes, I’m joking, mostly. But if you’re in a tool, and it can help you save time, then why not? Here’s a simple scenario: building a SELECT statement for one or more tables/views. Dragging and dropping tables to the worksheet is a pretty obvious feature – it copies the object names over for you. But did you know you had the option to get more bang for your…
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 right you will get something like this – If you’re having problems getting the panel to drop just as you…
This is turning out to be a bit harder to write than I orginially thought. I generally land in the laissez-faire camp, and I know what you’re thinking: “Jeff, we didn’t come here to read French!” Sorry about that, bad habits picked up from 4 years of public education instruction. In terms of American politics, think of me as the Ron Paul of database security folks. Set a user up to be able to do…
Are you sick and tired of playing with the same sample data? Do you shudder at even the mention of the name, ‘Scott?’ First of all, if you’re still using SCOTT, you should try out HR instead. And if you want some beefier tables and need to experiment with partitioning, then SH is the way to go. But eventually you will get to the point where if you see another SALARY or DEPTNO in a…
There’s a lot of confusion out there about the absence of a value, also known as NULL. It can cause havoc with your queries if you don’t account for it. Some folks confuse it with a blank space in a string. At least SQL Developer can make one thing a bit easier, interpreting NULLs in a data grid. By default when SQL Developer displays data in a grid, it indicates NULL with {null}. I’m a…
Just in time for the upcoming holiday shopping season, SQL Developer v3.1 (now available as an Early Adopter release), allows the developer or DBA to build ad-hoc deployment scripts. Need to ‘order’ that list of objects and underlying data for your test environment? Just add them to your cart and you’re ready for check-out! Once connected to 1 or more instances, you can use SQK Developer to pull selected objects from multiple databases into a…
Got a great question off the Twitter-verse this morning from @ApoloDuvalis “..in SD (SQL Developer) you cannot use the same connection in a different command window until the busy command is done or aborted.” I know many of you aren’t familiar with queries that take so long to run that you have to wait on them, but believe me, they are out there! Anytime I need a query that takes more than a few seconds…