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.…
Ever seen this button and wondered what it did? You may write some SQL to help you…write some SQL. Maybe you want to execute that generated SQL, and you’re lazy. Well, it’s a good thing you have SQL Developer installed 🙂
Many of you are not DBAs or developers. You spend most of your time browsing tables, running queries, and answering questions that help make your business ‘go.’ The SQL Developer Connection Tree shows a whole lot of stuff that you might not ever use. So turn it off. Tools – Preferences – Database – Navigation Filter By the way, this a new feature for version 4.0, so if you don’t see it, it’s time to…