No, not your code. I want you to take a quick look at the visual preferences for SQL Developer. In an earlier post I pontificated on the top 10 options to tweak before starting to use SQL Developer. Now once you have the tool operating the way you want, I think it’s time to make it look the way you want as well. So I suppose this would be #11! If you’re going to spend…
A quick disclaimer: I was inspired to write this post after reading AmberIsMe’s take on why she doesn’t read your blog. It’s not personal. Actually, it is a little personal. That is the point of social media after all, right? Building personal relationships with folks you admire that you wouldn’t otherwise be able to in ‘real life’ Don’t let me put words in your mouth, but that’s one of the primary reasons I spend a…
Just so you don’t think I’m crazy, you should know that I’m a father to a wonderful two year old daughter. She’s awesome, except when she wants to act her age. When we get desperate, we turn on her favorite show. I have seen about 200 different episodes of Dora the Explorer. My Spanish is getting better, but I’ve got these really bad songs stuck in my head. I’m going to share one of these…
I’m not sure if I can help with the mind part, but I can definitely add some perspective on the line numbers. Quickly, let’s define just what the ‘gutter’ is in the world of programming and database GUIs. I found a good definition on Quantum Whale, a .NET component developer, and I’m going to quote them: Gutter: The gutter area can be used to display bookmarks, line numbers and outline sections. The gutter is the…
Updated: April 13, 2015 Reports are great ways to access data on demand without having to write and run the code over and over. Sometimes you want to take the results of a query and feed it to another query as an input or parameter. Wouldn’t it be great if you could fire off a report based on the selected value of another report? This is the basic premise of a Master/Child report. For this…
On February 14-16, I’ll be at the Colorado Convention Center in Denver, Colorado for RMOUG’s Training Days Conference. This is the largest regional Oracle User Conference in North America and attracts presenters from all around the country and the globe. I’ll be presenting: Presentation Name: SQL Developer Tips and Tricks for Developers Abstract: You use the GUI because you want to be productive, right? Do you ever get the feeling you’re only really using a…
SQL Developer is built by Oracle, for Oracle. It’s the database IDE. That’s my current elevator pitch, at least. But, SQL Developer is also a fully featured data modeling solution (have you been enjoying my data modeling posts?) AND a 3rd party database migration platform. The migration piece is the Migration Workbench. Since we support migrations from these other database platforms, wouldn’t it be neat if SQL Developer could connect and query those 3rd party…
Data models sure are handy. They tell a story – how does the information get stored as data? Just what is a ‘customer?’ Sometimes though our applications die and only leave legacy scripts behind. Or maybe you are a DBA and someone has given you a set of scripts to create some new objects in your database. You ask them for their model, and they just look at you with that weird blank stare. “We…
A question that comes up fairly frequently revolves around how to see your errors when working with PL/SQL in SQL Developer. Most folks are probably working in the worksheet – this is the default editor for your connection. Let’s take a look at this sample program 357013563672459b63d403_000005 If we were to create this procedure, we would probably expect some errors. So let’s run this in the Worksheet. I’m using Ctrl+Enter to execute this single statement.…
I’m going to go out on a limb and guess that most people who use SQL Developer do not realize it has a fully-baked data modeling tool built into it. It’s not like we hide it, but we kind of hide it. To open the Data Modeler inside of SQL Developer, navigate to the View menu, and activate the Data Modeler Browser, like so – Once opened, you’ll see a new ‘Browser’ panel beneath your…