We try to make comparing things easy to do. When you’re troubleshooting, you frequently need to know why A isn’t quite like B. So let’s look at a few scenarios. Execution Plans or Autotrace Runs Run a plan or autotrace. Pin it. Run another. Right-click on one, and compare with the other. Voila. Looking at Objects, Side By Side So what’s the difference between those two hockey stat tables? Open a table. Pin it. Open…
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…
I have found a lot of users like to tweak this preference without really understanding what it does: Standard JDBC also enables you to specify the number of rows fetched with each database round-trip for a query, and this number is referred to as the fetch size. [DOCS] So if you execute a query and the query returns 1,000 records and your fetch size is set to 100 – we will need to go to…
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.
A few quick things to remember: Try to always use statement delimiters Even before I go to execute this ‘statement’, SQL Devleoper is telling me I have a problem. The grammar check is failing. Notice those red squiggle lines? They actually mean something. So, add a semi-colon, or do this: Know the difference between executing a statement and executing a statement(s) as a script
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…
For the month of September I’m challenging myself to perform two different feats of strength: Do 5,000 push-ups in the month of September Post a SQL Developer Tip or Trick every day for the next 30 days I’ve noticed my posts are starting to go out once or twice a week, and I like to average three. So hopefully this mini-bootcamp of blog posts will me back on schedule. So, without further ado, Tip #1:…
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… 163692426367edea47993fc_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…
If you’re wondering why I would bore everyone with my pictures and frequent status updates/tweets from the past week – it’s so I could document the process of refurbishing my deck, or what some would call a porch. When my wife and I go to take a vacation, buy a car, do anything – we try to read personal blogs and reviews online to get the real story. I want to pay that treasure trove…
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:
