The crazy starts tomorrow. Most of you won’t be here. But. You can get the software being used to demo everything this week. The Developer Day VirtualBox image has been updated as of yesterday. The biggest update is that it has 12.1.0.2 of the database on it. All that In-Memory awesomeness 🙂 No pics today, I’m writing this in a taxi on our way to an Oracle nerd beer meetup! Ok, I started it on…
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…
Many applications will create user accounts in the database that do not own anything. They have privs to query the main application schema, but will never be used to create tables, views, etc. When you’re browsing the database via the Tree in SQL Developer, you probably won’t want to see these ‘fake’ users. Just Apply a Filter Make sure your data dictionary stats are up to date – this extra check for object counts could…
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…
Impatient? Want to run a query, then run another – getting both sets of results to a data grid? Don’t mind leaving cursors open? These are serious questions. But if you’re feeling adventurous, feel free to try this out. Select multiple queries Execute Or, if you prefer to watch the movie… Did you notice that ‘bonus’ tip? Mousing over the resultset grid gives you a context hint as to the query used to populate said…
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…
This post was almost NULL – I was deep in Power Point mode for Open World, and almost forgot to write today’s post! Also, another admission: I said back on Day 1 of this series, that I was planning on doing 5000 push-ups this month as well. Well, I gave up on that a few days ago. I’m still pushing them out, but 5,000 ain’t going to happen – sorry Philip! Ok, conscience clean -…
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…
In the current issue of UKOUG’s Scene Magazine, you can find a 5 pager on how to get started with the reporting feature in SQL Developer. Now, I could come up with a new tip or topic for today,’s post, or I could just cheat, and link to this other thing I already wrote. I’ll let you figure out which way I went here. Click on the picture to read the article. A few things…
If you’ve been paying attention, I’m not a huge fan of ‘automatic’ features. I like to use features on-demand. One of the default preferences in the tool is to open an object as soon as you click on it in the connection tree. But as soon as I want to drag an object to a model or to a worksheet, I lose my mojo and SQL Developer interrupts my workflow to open the object editor.…