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…
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?…
…there were email and VPN accounts. Had my first conference call, complete with desktop sharing. Direct deposit and tax forms are out of the way. Everyone (I think) is remote, so instant messaging is one of the preferred communication methods. Looks like we’ll have a chance to meet in person for a team meeting outside of London in a few months. Am I overwhelmed? Not as much as I had feared. If I let in…
Since I announced my new job at Oracle, I’ve had more than a few friends and associates approach me about databases. They’ve always wondered just what it is that I talk about all the time, or perhaps they want to get their feet wet and want to know more about data in general. I think this is fairly normal and expected, especially as just about everyone has some sort of interaction with a database. As…
The Smith family is an Android family. However, we’re not so weird as not to own some Apple products as well. We have a Mac Mini, 1st Gen AppleTV, an iPod, and an iTouch. The iTouch is my wife’s toy. She spent a LOT of time building a playlist that had just what she wanted. She lost that playlist in iTunes though when we ditched our Windows Home Media PC and bought the Mini. She…
I loved my job at Quest Software. I loved the people, the technology, and usually our customers! I got paid to talk and think and write. But that chapter of my life closed last week. There were so many friends and close acquaintances I made over the last decade that it was impossible for me to reach out to all of them. So I hope if you are reading this now, you’ll know how grateful…
Yes, a post about something other than Toad or Oracle! I hope you folks don’t mind, but I need to brag a little bit 🙂 My wife and I welcomed our son to this world on Tuesday night! My wife was extremely brave and did the whole thing without any sort of pain medication. Not that she had much choice – the labor process was so fast that any epidural wouldn’t have had time to…
A Toad user posed this question today: Is there a way to move a (marked) TABLE mytable123 from Tablespace AAA and Schema BBB to another Tablespace USERS and Schema MYSCH? Let’s tackle the 2nd and easiest part first! Moving a table or partition to a new tablespace is pretty straightforward: ALTER TABLE table_name MOVE TABLESPACE tablespace_name; The ALTER TABLE MOVE clause is documented and diagrammed in the Oracle Docs. However, the user ALSO wants to…