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…
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 stays on in the first line. It would be helpful if the script execution either points to the current DML…
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…
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 to get your work done as fast as possible. Wouldn’t it be nice if your favorite tool could give you…
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…
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 I assign them all to be of the “Dimension” Classification Type? You could do this slow-by-slow… Select Table and Right…
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…
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 as I’ve probably covered the topic you’re asking about in more depth and detail. If you missed the ‘show’ and…
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…