Full Disclaimer: I’m speaking at KScope. When I talk about how awesome the speakers are, I’m excluding myself, naturally. ODTUG USED to stand for ‘Oracle Developer Tools Users Group.’ Their scope has broadened to include more than just the developer audience, but it’s nice to remember this was and mostly still is a group FOR developers BY developers. For as long as I can remember, OK since 2005 or 2006, the best speakers and experts…
An interesting question popped up on the forum, and I thought I’d share my ‘answer’ with you folks. I figure this is something a lot of folks do several hundred times a day – pulling up a frequently used database objects in the browser. The question: Is there a way to define a shortcut to take me to a Table, package, etc of interest? I have many DBs defined in SQLDeveloper and it’s a pain…
Oracle’s free data modeling solution, Oracle SQL Developer Data Modeler, has been updated with the release of version 3.3. I’ve already previewed a few of the new features here, and I’ll continue to talk more about the latest and greatest features. You can see the full list of new features and download the tool on our official OTN Product Page. A Few Housekeeping Notes We’re updating Oracle SQL Developer Data Modeler today, but as many…
When I’m doing demonstrations of Oracle SQL Developer, I’m frequently asked about our support for datatypes like XML, BLOBS, Timestamp, etc. When I’m put on the spot like that, I have a tendency to forget that I already have tables setup for this. So I end up writing a query to find a table that has a specific datatype. And that just … sucks. So I’ve written a report to do this for me. AND…
An interesting question came up on the ORACLE-L mailing list this morning regarding table comments: Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column “No comment”. Does anyone do this as a regular best practice? I would prefer to see this abstraction in a data model, maybe not pushed to the database layer, especially since not all RDBMS engines have “comment” functionality. The thought is…
In an earlier blog post I listed my ‘Top 10 Preferences to Tweak…’ Instead of amending that to Top 14, I wanted to give a fresh and updated take on some features that directly impact productivity and data quality. After doing three customer calls in three consecutive days, I realized I was spending a lot of time on these preferences and figured the rest of y’all might need a reminder as well! 1. Click but…
Getting the Windows ‘busy’ hourglass cursor is sure to raise anyone’s blood pressure. Sometimes you’re left there waiting because a resource you’re attempting to access is already being used by someone else. So you get to WAIT. You are being BLOCKED because what you want is LOCKED. How can you see what the hold-up is? And more importantly, how can we figure out who or what is causing the delay so we can go KILL…
…to Create Alternate Visual Presentations of your Diagrams Your data model tells a story, and we all learn as small children that the best stories have pictures – the more the better! There’s a reason I try to always have at least one picture in my blog posts – even adults are easily distracted. We want to skim the story, or just jump ahead to the ‘good stuff.’ Our models by default have a single…
So you’ve been working on your data model, and you’re wondering how far ‘out of whack’ it is with the production or development database instance. Sometimes folks manage to compile changes into the database, bypassing your design process and rules. If you’re wondering how to compare 2 models instead of your model with the database, read this. So your question is basically, show me what’s different. You just need to decide what version of the…
Love vi? Prefer emacs? Want the power of the 80’s added to Oracle SQL Developer? You can do that via our External Tools feature. And you can even have SQL Developer throw over your open file into vi, edit it, save it, and refresh the buffer in the worksheet to reflect the file changes. Here’s how. Install vi I went and grabbed vim, Windows 7 x64 to be exact. Then in SQL Developer I accessed…