I received a very interesting question from a reader the other day, which is awesome for two reasons. One, it gives me something to think about and play with. And ‘B’, it provides me with material for today’s blog post. So here’s the original question – We would like to capture inofmation like who, when and why a user connected to a database in production using SQL developer, so i was wondering if is it…
I was asked recently if SQL Developer supported multiple children reports. The answer is ‘yes’, and here is a post showing how to achieve this. First I need to clarify the answer a bit. Reports have a ‘master’ record set. These records can be used to ‘look up’ related records in a ‘detail’ set. This detail set becomes the ‘Child Report.’ A parent can have 1:Many children. However, children cannot be parents (at least not…
Debugging PLSQL is one of the primary features of Oracle SQL Developer. Yes, its the IDE for the database, but PLSQL is the database’s programming language. It really, really needs to support all things PLSQL. Programming languages need modern day amenities if they are to be adopted by mainstream developers. One of those amenities is a debugger. A primary challenge I face as an advocate for Oracle, PLSQL, and our developer tools is that database…
It helps to know the developers. They can tell you things that are not documented in the help or release notes. They mostly don’t hide things on purpose, mostly. They often build things into the application to aid themselves, but usually it’s for the end user’s benefit. @krisrice sent me over a few nuggets to share with you folks. These are truly ‘tricks.’ Cool things that you would not know about unless someone showed them…
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…
I’m not saying there’s anything wrong per se with SQL Developer’s tree control for navigating your connection objects. As a matter of fact there are a few things to really admire about the tree implementation. Just in case you have NO IDEA what I’m talking about, here is the tree in all its glory. Scrolling can get tedious on large databases. So here’s a few tips for those that are keyboard savvy: Navigate the tree…
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…
Updated November 19. 2018 The ‘Holy Grail’ of software tools is the environment where things are made easy, but not at the expense of usability or simplicity. You use a tool because it makes something ‘easier’, but some software products are anything but. SQL Developer is fairly scaled down. You have a few toolbars, several menus, and 2 driving windows – the Worksheet and the Browser. But what if it could be even simpler? SQL…
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…
Did you miss the big news yesterday? We released the next version of Oracle SQL Developer, 3.1. SQL Developer is the IDE for the Oracle database. Millions have downloaded it, more have used it. We try to do one to two releases a year and look to support those folks doing development, management, modeling, migrations, reporting, data mining, … you get the idea! Don’t have version 3.1 yet? Go download it NOW. Today I wanted…
