After a VNC session with the always brilliant @bamcgill, I now know how to rename a worksheet. So when you open a worksheet, it’s attached to a database connection. The worksheet name is a property, and it defaults to the connection name. So you DO you have a lot of control over the worksheet name. This is the primary reason I advocate using well thought out names for your connections. But maybe you want to…
Our stored procedures often capture information and store that data as a string or number. But sometimes we need to process more than just a single value. PL/SQL allows you to do this via collections. Now, if you’re looking for help getting started with collections, I would start with Using PL/SQL Collections and Records Oracle Docs The PL/SQL Guru, Steven Feuerstein Once you have a program working, and you want to know what your data…
The quick answer: ‘Mostly.’ Simple question of the day – how do I get SQL Developer to word wrap like Notepad does? If you don’t know what I’m talking about, then here’s a screenshot of some text before and after word wrap is applied in Notepad: No Word Wrap Word Wrap A SQL Developer Example Here’s some text to play with: 127695889269ce20d0dc665_000002 That’s more than 80 characters and it’s broken up over multiple ‘words.’ With…
One of the great benefits to having an application developed on the Java platform is the ability to run it on many different operating systems. While Windows may still be the corporate standard in more shops than not, geeks worldwide know that Apple’s hardware and OS (OS X) are ‘superior.’ With yesterday’s release of Mountain Lion (10.8) I figured this was a good time to do a quick write-up on how to get started with…
This feature is sure to define your placement into one of the following camps: I love it when my IDE helps me with my code I hate it when my IDE inserts code I didn’t explicitly type STOP! If you’re using version 4 or higher of SQL Developer, Click Here. And the feature is – Autogenerate Group By clause The help defines this preference/feature as: Automatically generates a GROUP BY clause if you manually enter…
This drove me nuts for a few minutes, so I figure you might need help too. That probably explains why you had to Google ‘Block Select’ and wound up here. Here is what you want: There’s No Trick, But You Do Have to Enable It The default behavior is to do a normal ‘wrapping’ selection of text. You can disable this under the Edit menu. Selecting Text In Action On a newer version of SQL…
Want to monitor or browse the sessions running on your database? You could query v or gv$session and get an idea of what’s happening. But often you want and need to join into waits, locks, performance data, plans, etc. to get a full picture of what your users and applications are doing in the database. Enter the Tools – Monitor Sessions… screen. This is actually a Master/Detail report! I know, shocking – right? You can…
Oracle SQL Developer by default automatically opens the object editor when you click on an object in your connection tree or schema browser. For most folks this is very convenient. But if you are selecting objects to drag them to a model or to the worksheet, this can get annoying as the focus of the screen changes when you don’t want it to. The other scenario this feature might disrupt more than delight is when…
Being a short week due to the holiday, and with everyone enjoying their Summer vacations (apologies Southern Hemispherians), I reckoned it was a great time to do one of those lazy recap-Top 10-Reader’s Digest type posts. I’ve been sharing 1-3 tips or ‘tricks’ a week since I started blogging about SQL Developer, and I have more than enough content to write a book. But since I’m lazy, I’m just going to compile a list of…
This wasn’t my first rodeo, and it wasn’t my first Kscope, but it was probably my favorite one. What is Kscope? It’s the annual conference for the Oracle Development Tools User Group. 1,000+ attendees from 20+ countries with an average Jeff Klout score of 65. I just made that metric and score up, but this conference attracts the best and brightest in the Oracle database space. I’m not just talking about the speakers either. The…