For the month of September 2014, I published a SQL Developer tip each day. September has 30 days, so that equated to 30 posts. Now normally, I post anywhere from 1-3 posts a week. Going from that to 7 days a week meant a few things: posts were going to be shorter – especially on the weekends there was going to be some retreaded content – but I did try to give everything a fresh…
I had a pretty good week of presenting at Open World this week. 3 solo presentations, all well attended. But in one, I had a technical issue – that’s code for I was having problems because I was using the wrong database connection – when trying to show off the Real Time SQL Monitoring support feature in Oracle SQL Developer. So in case you were there, and left a bit disappointed, I cut this quick…
Updated Wednesday, July 6, 2016 Setting up a new install of SQL Developer this morning – exciting stuff as we’ll be teasing some v4.1 features at Open World this week – I found myself immediately tweaking the following preferences. Font – we’ve talked about this a few times, but I make it bigger to make it easier to see in presentation mode I also change the font itself, Dialog is horrible Open Object on Single…
Around 60 of us Oracle folks showed up this morning to take a little run across the Golden Gate Bridge. It took effort to get out, effort to run, and a lot effort to jump for 30 or 40 pictures – thanks Yury! The Database tools team showed up in force – 4 of us SQL Developer types and more than a few of the Oracle APEX developers came out to support the event. We…
Using the mouse sucks. You love the mouse. Leaving the keyboard gives your fingers a wonderful vacation. If you fall in the second camp, this post isn’t for you. But, if you want to be able to get from your query down to your results or explain plans without having to touch your mouse, this post is gonna be your awesome-sauce reward for coming to work on a Friday. You just need to know the…
We get lots of questions around how to model specific partitioning schemes in Oracle SQL Developer Data Modeler, and we do support all of the different ways to part and subpart your data – but today I want to show you: Where to see the partitions in the model How to bring in everything BUT the partitions Where are my partitions? When looking at the table in your data model, you won’t see the partitions…
A forum question today reminded me that I’ve never talked about dealing with your broken Oracle database objects in SQL Developer. So let’s take care of that in today’s post. Browsing Show me EVERYTHING that is broken Run the report. Optionally provide a schema to filter the report, the default is to show the entire database. I want to fix an entire schema’s worth of broken stuff! Right-click on your connection. Set ‘ALL OBJECTS’ to…
As much as I like the traditional explain plan support in SQL Developer, and even the ability to pull cached plans out by the SQL_ID – sometimes you just want to get the plan the old fashioned way. The New Way The Older Way Ugh. That’s a little icky to read. Remember – you need to set a fixed-width font. Tools – Preferences – Code Editor – Fonts Fonts Are Very Important If you’re having…
This question comes up very frequently: Why can’t I see my compilation errors when I’m working with PL/SQL? Because you are either: using the wrong editor, or not asking to see the errors SQL Developer is the PL/SQL IDE for the database. So we obviously need to have those ‘fancy’ IDE features like a debugger, compilation message support, profiling, bookmarks, etc. We provide this with the Procedure Editor. You invoke a procedure editor whenever you…
Quick and clean, what’s that? Consider the following: 1016976345681ed77acd770_000004 I call that ‘quick and dirty,’ and I imagine you have used this technique many, many times. But, I wish it would have grabbed column comments, indexes, maybe even the partitions. Partitioning a table after the fact is pretty much a no-go. So what are we to do? Well, if you have SQL Developer v4.0.3, you can simply right-click on a table and… Use as a…
