So this tip requires you upgrade to version 4.0.3 of Oracle SQL Developer – more on that in a second. Version 4.0.3 is 95% bug fixes. One of those bugs was submitted by my fellow product manager, Maria Colgan. Perhaps you know her on Twitter as… Tweets by @db_inmemory Anyways, she is going to be using our favorite tool to help teach you how to use the new 12.1.0.2 database feature known as ‘In-Memory.’ What…
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…
What’s a very large script? That’s a subjective question, and the answer will depend somewhat on the hardware specs of your machine. I got this question yesterday: @thatjeffsmith is there a limit to the number of lines I can paste into the code editor in SQL developer? — louise mcscootash (@metalouise) September 12, 2014 I enjoy these questions. They’re 99% of the time, not theoretical. She had obviously ran into some sort of wall. And…
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 🙂
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…