SubViews are a sub-collection of model objects. They are very useful for breaking up very large designs into smaller, easier to digest pieces. If you need to brush up on the topic a bit, try these posts. I recently received a note from a user, we’ll call him ‘Galo’ – who was having problems figuring out how to add a table to an existing subview. It actually took me a few minutes to figure out.…
Today I want to talk about how to version control your Data Modeler designs with Subversion. Oracle SQL Developer Data Modeler is free. Subversion is free. So for no money, you can design your database objects, and version control them for one or more people. I’ve put together some slides for your enjoyment: Oracle SQL Developer Data Modeler – Version Control Your Designs from Jeff Smith Psst, slide #16 has the ‘good’ stuff But Wait…
Starting the debugger CAN be as simple as hitting this button in Oracle SQL Developer: But But, you need to make sure of the following: You have compiled for debug You have the privs You have a breakpoint set OR you have set the debugger preferences to start with a ‘Step Over’ On Database 12c, you’ve done setup the network access control list That’s a lot of buts. Let’s plow through them! Wait, wait, wait.…
I do a lot of live presentations and demonstrations. I’m frequently asked, ‘why does your SQL Developer look that way?’ or ‘How can I make SQL Developer work that way?’ It’s all about the preferences (or options.) So here’s what you can do if you want to be like me. By the way, I can’t really help you if you want to be like me, that’s a matter for a psychiatry blog. Here are the…
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…
