How deep do you go in your software? Do you make it at least 1 click deep? I’m talking about right-clicking with your mouse. Software folks are often accused of hiding things on context menus, but you have to remember that software is engineered and developed by folks that are comfortable with computers – and we just assume everyone knows to ‘right click everywhere.’ You may have noticed something was amiss when you first used…
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…
Entity Relationship Diagrams tell a story. An employee is assigned one department. A location can house one or more departments. Jeff doesn’t have a boss because he is ‘the man.’ It can be challenging to understand the nature of your data by simply reading through the list of Foreign Key constraints for a table. Who wants to read this when you can instead see this So how do you go from one to the other?…
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…
Regardless of your role or responsibility, if you work in the database, you’re going to spend a lot of time looking at data. This is usually what will push someone from the command-line to a GUI – the spreadsheet look and feel for browsing tables or query results. Since you’re going to be spending so much time in these grids, let’s make sure you know the basics. I know you’re not writing very many SELECT…
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…
Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying to wrap your head around something with several thousand (or more!) objects? Enter the SubView SubViews allow the user to…
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…
I think one of the dirty secrets in the software business is how LITTLE feedback we get from our end-users. You know they are out there though, gritting their teeth, cursing the day someone trusted you with a keyboard and mouse. Some of this software is very expensive to boot, so one would expect these users would be very vocal with their feedback. In actuality, I reckon we only only hear from a very small…
Oracle SQL Developer is made available to you for free, and is chock-full of features for the developer, DBA, or data-junkie. We do our best to give you everything you need to be successful in your job, but also recognize that we can’t do EVERYTHING. While SQL Developer is NOT an open-source project, it does provide a framework that allows for other developers to build their own plug-ins. Don’t know Java? No problem, you can…
