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 5517316076812fbeac6ca7_000000 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…
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…
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 good folks at Oracle, namely @krisrice, approached me this past Summer with an offer I found myself unable to refuse. The short version would be something like, ‘Hey, come join our SQL Developer team.’ So next week, I will start the next chapter of my professional life as the Product Manager for Oracle’s primary database development tool. This is a very exciting moment for me. I remember first seeing Oracle in my senior year…
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…
It’s still me! That dude that spends a lot of time talking technology, databases, software, and the occasional bad joke. I screwed up. @BrentO told me 2 years ago that it’s better to use your real name on Twitter. And I didn’t listen to him. So now I get to take my medicine and go switch everything over to my new account – ThatJeffSmith. It’s not a coincidence that my new Twitter handle matches the…
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…
Two quick apologies – 1)This post may ramble a bit more than usual, and B)It’s not my intent to insult or degrade any of the folks I help online. This blog serves as my conscience and my therapist, and I’m not in the mood to cover technical topics today. First off, you may wonder what I mean by ‘user.’ Surely that is synonymous with the term ‘customer?’ You might be surprised how many people actually…