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: 1015504219680cccd64ba52_000003 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…
You want to connect to the database, but: you can’t get to the server directly, or you can’t talk to the listener port If ONLY there were a way you could smuggle your database connection through another network connection that could do those things. Well there is, and it’s called an SSH tunnel. SSH talks on port 22 – which is more often than not open on your locked down servers. So if you can…
So this tip requires you upgrade to version 4.0.3 of Oracle SQL Developer – more on that in a second. Version 4.0.3 is 95% bug fixes. One of those bugs was submitted by my fellow product manager, Maria Colgan. Perhaps you know her on Twitter as… Tweets by @db_inmemory Anyways, she is going to be using our favorite tool to help teach you how to use the new 12.1.0.2 database feature known as ‘In-Memory.’ What…
