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…

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…

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…

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…

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…

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…

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 Developer’s Worksheet allows you to ‘pin’ the Query Results, Explain Plan, and AutoTrace panels. While pinning the Query Results panel…

Some folks find this hard to read 240026161616b6b8857164_000001 If your computed column code or column names are very long, they’ll often trail off the edge of the viewable screen. If you’re missing a comma somewhere, you’re bound to run up against an ORA-. You want to know right away WHERE you’re missing the separator. I covered this ‘debate’ earlier in ‘Trailing or Leading Commmas.’ If you would like to get your code to FORMAT with…

I was perusing the SQL Developer Feature Requests Exchange and was not surprised to see this – a request to have the Query Builder disabled. My favorite (and most predictable) comment among the voters for this request is something along the lines of ‘feature totally useless for us professionals’ Let’s explore that for a second. First of all, I’m not judging this user’s point of view. It’s probably quite prevalent amongst the experienced database folks…

It’s amazing how the ‘little things’ can often make the biggest impact on the end user experience. Example: when you ask your software to do something, you want a visual indicator or feedback dialog to let you know how that request is being processed. Imagine submitting a order request on your favorite shopping website and not getting a response back. Did they accept my order? Will I get my book? Did they take my money?…

In case you’re curious, I’m calling yesterday ‘Day 0’ as it was spent doing trivial things like getting email setup. Today I feel like was closer to a real day of work. I spent a few hours this afternoon going over some request from the users. One stuck out pretty prominently – ‘Keep-alive functionality’ The basic gist is at some point your connection to the database is terminated due to an inactive connection. This can…

RSS
Follow by Email
LinkedIn
Share