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…
I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… 42404438669ca67fe84b5a_000000 …but I’m lazy. So this: The Setup Open your preferences and go to the SQL Editor Code Templates. As you code these, you recall them from what you label them via the ID, not…
I get a variation on this question at least once a week, if not more frequently. I’m from Israel, and the language on the databases is Hebrew. When I use the old and deprecated SQL*Plus (windows rich client) I can see the hebrew clearly, when I use the latest SQL Developer, I get gibberish. This question appears on the forums about every week or so as well. So what’s the deal? Well, it starts with…
Very quick and short post today. The question: In version 4 of Oracle SQL Developer Data Modeler, how do I get the names of foreign keys to appear on the relational model diagram? First of all, right click in the diagram space: With this on, your diagram will now look like this:
Did you know you can run SQL*Plus type scripts directly from the web? Now, I’m going to assume the following: You know, trust, and have tested these scripts You don’t assume that everything on the Internet is true That Tim doesn’t think I’m trying to suck up to him, much So, in a SQL Worksheet, run your script, and just reference the URL of the file in question. Store your scripts on Dropbox, perhaps? I’m…
