One of the coolest parts of my job is that I actually get to use the software that I help manage. The end-user perspective is hard to imagine sometimes, but when you ARE the end-user things become clear as day. This morning I spent quite a bit of time in DataPump and the SQL Developer Cart. I needed to copy a schema from databaseA to databaseB. Everything’s relative, and this goes double when it comes…
So while hanging out with a bunch of co-workers last week, someone mentioned they had this trick. The challenge is knowing how many rows you have in your result set before you actually read them all. You see, Oracle has no way of telling us how many records are in our data set before we actually fetch the entire data set. Yes, Oracle gives us %ROWCOUNT, but that only tells us ‘…how many rows affected…
Updated: July 16, 2020 There are many data types to choose from when defining your table columns. The eighty percent rule tells us we can probably get away with a smaller subset of data types, 8 times out of 10. Here is what the ‘TYPE’ control looks like in the modeler when defining a column: I was curious to see what data types were used most in my 11.2.0.3 database, so I fired off a…
The Late Show with David Letterman used to have a bit called, ‘Stupid Pet Tricks.’ I quit watching because I prefer his Scottish and funnier future-replacement, Craig Ferguson. But I will take advantage of some Google-Fu to drive some traffic to ye olde blog (can you tell I’m in the UK this week?) So most folks GET copy and paste in Windows and Mac. Ctrl or Apple + C for copy, and + V for…
SQL optimization and tuning is fun for a lot of folks. For others it’s a affirmation that the database is ‘magic.’ I fall somewhere in the middle. No matter where you find yourself on that spectrum however, it’s pretty safe to assume that at some point you will look at an execution plan for insight to your poorly performing SQL statement. Viewing a plan in SQL Developer is pretty easy, just hit the ‘Explain Plan’…
Want to confuse an Oracle database n00b? Ask them if their query takes into account the time component of a date when they code their WHERE blahDate between … AND … logic. But sir, my dates do not have a time associated with it. You must be confusing this with TimeStamp. See, that has the word ‘time’ in it, so that is where Oracle keeps time stuff. It’s at this point that I seriously start…
No, not your code. I want you to take a quick look at the visual preferences for SQL Developer. In an earlier post I pontificated on the top 10 options to tweak before starting to use SQL Developer. Now once you have the tool operating the way you want, I think it’s time to make it look the way you want as well. So I suppose this would be #11! If you’re going to spend…
A quick disclaimer: I was inspired to write this post after reading AmberIsMe’s take on why she doesn’t read your blog. It’s not personal. Actually, it is a little personal. That is the point of social media after all, right? Building personal relationships with folks you admire that you wouldn’t otherwise be able to in ‘real life’ Don’t let me put words in your mouth, but that’s one of the primary reasons I spend a…
Just so you don’t think I’m crazy, you should know that I’m a father to a wonderful two year old daughter. She’s awesome, except when she wants to act her age. When we get desperate, we turn on her favorite show. I have seen about 200 different episodes of Dora the Explorer. My Spanish is getting better, but I’ve got these really bad songs stuck in my head. I’m going to share one of these…
I’m not sure if I can help with the mind part, but I can definitely add some perspective on the line numbers. Quickly, let’s define just what the ‘gutter’ is in the world of programming and database GUIs. I found a good definition on Quantum Whale, a .NET component developer, and I’m going to quote them: Gutter: The gutter area can be used to display bookmarks, line numbers and outline sections. The gutter is the…
