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 it can be accessed via SQL. So how can I leverage all the data in my designs without having to…
In a few weeks I’ll be speaking at the Database Symposium at the ODTUG KScope13 conference. My topic, ‘SQL Developer v4.0’ will be one of the first times I spend an entire hour showing off our new features in the upcoming release. While not yet publicly available, and while I can’t comment on when that will change, I can say we’re getting closer 🙂 I thought I would reward my loyal readers with a quick…
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 Preferences Pinning Objects At the top of every editor in SQL Developer, you’ll see a push pin button in the…
ODTUG’s KScope13 event is just around the corner. This year, as always, we have a ton of Oracle SQL Developer content ready to share in the form of sessions, hands on labs, and symposiums. I’ve noticed a few of our users are also sharing their experience in their own sessions – awesome! If you’re going to Kscope13, you’ll want to make sure to carefully setup your schedule so you don’t miss a thing 🙂 I’ve…
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 recommending you use JDeveloper, Fusion, and our other middleware technologies to build your applications. What I want to get to,…
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 database and generate an ALTER script? The answer is easy: Upgrade to version 3.3 of 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 table? First, you know what a SubView is, yes? It’s what we call a ‘sub model’ – or a subset…
Using VS Code? You can take advantage of SQL Developer there as well, it also allows you to cancel your queries. 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…
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 and the next begins. A quick example: But I Don’t Want to Use Commas! Ok, well no need to shout.…
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…
