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…
You know that thing where you’re sitting shotgun, or the horror – in the backseat – and you notice the driver doing something that drives you crazy? For me it was my best friend in college who refused to acknowledge that his car had 4 gears. He’d never shift out of 3rd gear. Somehow I’m still sane, mostly. Well, there’s something I notice folks doing in SQL Developer that drives me just as crazy. They…
Let’s say you have some objects you need to quickly create somewhere else. And you want to it such that it can be scripted/scheduled. I am using the Cart right now to build out a demo environment for folks that want to show off some SQL Developer features. For instance, I’m building a ‘shopping list’ to cover things such as: Spatial data Redaction 12c Scheduler Chains BLOB viewer Partitioned data – enough rows to make…
I’m at a friend’s house, sans laptop, so today’s post will be short and sweet. Also, no pictures! In your connection tree, on an active (connected) connection, right-click and select the Schema Browser. If you hop around users/schemas frequently in a database, you may enjoy the drop-down control for toggling.
Want to connect to an Oracle Database, but you can’t because of these errors: ORA-12545, ORA-12541, ORA-12514, & ORA-01017 ?
Someone asked the other day, ‘how can I make tables show up in blue?’ In the preferences, find the ‘PLSQL Identifier’ entry in the PL/SQL Syntax Colors entry, and set it to whatever color you’d like. Another example… Grammar Squiggles, They’re Hard to See Sometimes This time, look for the ‘Disconnected Join Graph’ entry. One more… Classic Green Screen The very first entry, ‘Default Plain text’ – set that to background, ‘black,’ and then set…
This might be the most important set of preferences in Oracle SQL Developer. The settings on this page directly impact how your queries run and the results they return. One of the most curious and fun to debug questions I get from users is something along the lines of… Why does my query return X in SQL Developer but Y in SQL*Plus or _________________ ? Most of the time, it comes down to differing NLS…