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 [...]
sqldev
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 [...]
Twitter
RSS
GooglePlus
Facebook