I’m writing this at my departure gate in Denver, waiting for my flight home from the Training Days ’14 event hosted by the Rocky Mountain Oracle Users Group (RMOUG.) The RMOUG conference is the unofficial kick-off for Oracle conferences for the new year, and it’s one of my favorites. I helped put together a panel discussion on professional development, and one of the topics that came up was the ability of employees getting the approval…
Ever wonder what all the red, yellow, and purple marks in your procedure editor are supposed to tell you in the Oracle SQL Developer Procedure Editor? No idea what I’m talking about? This: This is the editor trying to help direct you to where you might have problems, instead of you having to to scroll the text looking for the squiggles. What squiggles, you ask? These: Mousing over the line shows you the Compiler Warning.…
Going through our enhancement requests in The Exchange this week, I was struck by how many folks were asking for features that are already there. There were at least three requests for being able to define how the Indexes are handled for table columns defined as Primary Keys or Unique. Here’s an example that summarizes the general issue: There is currently no way to specify storage options for unique constraints in a table. Since it…
You are using Oracle SQL Developer, and you want to create or open a design in the Data Modeler. How do you GET to the Modeler? Oracle SQL Developer Data Modeler is a standalone solution that is also shipped in SQL Developer as an extension. The user interface of the Modeler is folded into SQL Developer. If you are going to be doing just a quick-and-dirty operation on your design, working with SQL Developer will…
Wait, I thought SQL Developer was for developers? Yes, but it also provides a ton of features and value for the DBA. So if you’re already in SQL Developer to browse a table or run a query, you can fire up the DBA features under the View menu (and maybe save yourself an alt-tab to your browser and OEM.) We had a nice live webcast today with the good folks at ODUTG on this subject.…
You’re excited to see that defining triggers and sequences to populate identity columns in Oracle Database is no longer required. You have an Oracle Database 12c instance up and running, and you’re ready to hit the ground running. Wait, what is Jeff talking about? Ok, let’s say I have a ‘BEER’ table. My Primary Key (PD) will be an integer. I want BREWERY #1 to have an ID of 1, and then each new BREWERY’s…
You don’t need to have an Oracle Client installed on your machine to use Oracle SQL Developer. Everything you need to connect to Oracle Database is provided by the JDBC driver included with the download. So you can be up and running in usually less than 5 minutes. But if you DO happen to have a Client on your machine, you’ll be happier. If you’re too lazy to go read the above post, here it…
There are many hundreds of interesting blogs in the Oracle Database space to choose from. I’m happy to say that about 300,000 of you spent at least a couple of minutes on my blog in 2013. In case you didn’t have a chance to read all 105 or so new posts, I’ll share with you the highlights. Before you run away screaming, thanks for hanging out with us in 2013 and we look forward to…
On a new machine, maybe even a Mac? I have more specific details on how to get the tiny UI rendering issue for SQL Developer fixed here on StackOverflow. Today’s Question: Are the Tree View fonts configurable? (E.g., Connections). I am using a high-resolution display (1920×1200) and they appear quite small. And the answer: Yes! Oh, but you probably wanted the how as well…OK. Here’s what the tree UI looks like out of the box…
A new version of Oracle SQL Developer has been officially released. Oracle developers, DBAs, and data professionals will find that v4.0 is perhaps our best release yet. Of course, we always say that 🙂 So here’s 10 reasons to go upgrade. 10. Version 3.2 is more than a year old. Version 3.2 was released last November. Tens of thousands (maybe more!) of man and woman-hours have gone into the making of version 4. 9. New…