Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database. And when something is in a database, then [...]
Monitoring Scripts as They Execute in Oracle SQL Developer
Interesting question from the forums: I’m doing multiple Inserts on a table using a script file (.sql) in SQL Developer. Since it has a lot of statements, I would like to check the progress of it somewhere in the application window. But I don’t see any progress of lines being displayed anywhere. The focus simply [...]
How to See Two Tables at the Same Time in Oracle SQL Developer
Another post from the FAQ files: HOW TO OPEN MULTIPLE TABLES IN SQL DEVELOPER SIMULTANEOUSLY I’m guessing the user is in a hurry, hence the shouting and lack of punctuation. But that’s OK, I think we’ve all been there. There’s a couple of different ways to get this end result: Use the Pins Change the [...]
Ever Run a Truncate, Drop, or Delete in the Wrong Database?
Hurts, doesn’t it? And tools make it so easy to do this. Even though your tool probably reminds you where you’re at, your brain often just starts running after the next task. And usually your fingers are even a few steps ahead of your brain. And then you get into trouble. All because you’re trying [...]
An Oracle Designer Feature: Generating Table APIs with Oracle SQL Developer
Have you heard of Oracle Designer? Perhaps you even still use it? Designer incorporates support for business process modeling, systems analysis, software design and system generation. I don’t want to get you too excited, because this technology is being phased out. You can read the official statement of direction here, but but going forward we’re [...]
How to Synch your Oracle SQL Developer Data Model to a Different Database
First a couple of quick notes: You can synchronize your model or your database and generate an ALTER script When you import one or more objects from a data dictionary to your model, it ties that model to that particular database So the challenge presnted is: who do I compare my model against a different [...]
How to Quickly Set Classification Types for Tables in Oracle SQL Developer Data Modeler
Your relational model may for a data warehouse or star schema where you need to define a table as being a dimension or fact. Or maybe you’re like my friend who asked me this question last night: If I’m looking at about 90 Dimension tables which all have the name prefaced by “Dim” how can [...]
Won’t You Be My Neighbor? Selecting Related Objects in Oracle SQL Developer Data Modeler
I loved Fred Rogers. He helped raise me. Nicest guy ever? So what does he have to do with Oracle SQL Developer Data Modeler? One word, ‘neighbors.’ I got a good question from a new user yesterday: Is there a quick way to add all the tables (to a subview) directly related to a specific [...]
Die! Or How to Cancel Queries in Oracle SQL Developer
I’m not sure why, but it appears many of you wish you could take back your SQL queries. It’s like that one time you posted that picture on Facebook and immediately (3 days later) you realized it wasn’t a great career move. Maybe that data you asked for wasn’t going to be that helpful if [...]
Questions & Answers from SQL Developer Tips & Tricks ODTUG Webinar
We had a great webinar yesterday with more than 350 people attending. Even tacking on 10 minutes at the end, I didn’t have enough time to answer all the questions (31!) So I’m going to tackle them here in quick order. If you want a more detailed answer, use the search form on your right [...]
SQL Developer: Preferences for Delimited Text Exports
Yes, it’s true. Some people export their data to formats other than Excel. Another popular format is ‘delimited,’ where fields are defined by a delimiter. The most famous of these is CSV, a comma separated values file. So your data can be read by another program quite easily because it knows where one field stops [...]
Oracle Developers Should Go to ODTUG’s KScope
I promised @oraclenerd that I’d make a video talking about why I thought KScope was a ‘must-attend’ event for all Oracle developers, but my web cam is acting up. In the meantime, here’s a quick plug for my favorite independent Oracle conference! Full Disclaimer: I’m speaking at KScope. When I talk about how awesome the [...]
Oracle SQL Developer: Database Object Shortcuts?
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 [...]
Oracle SQL Developer: What’s Next?
Software development never really stops. The development cycle is truly a circle. Once a release is ready, the developers don’t go on break awaiting orders. There’s always the next sprocket to build or widget to refactor. And so comes one of the best parts of my job: helping figure out what those widgets and sprockets [...]
Oracle SQL Developer Report: Tables By DataType
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 [...]
Twitter
RSS
GooglePlus
Facebook