30 SQL Developer Posts in 30 Days, Day 25: Importing Partitioned Tables to a Data Model

thatjeffsmith SQL Developer 0 Comments

We get lots of questions around how to model specific partitioning schemes in Oracle SQL Developer Data Modeler, and we do support all of the different ways to part and subpart your data – but today I want to show you: Where to see the partitions in the model How to bring in everything BUT the partitions Where are my …

30 SQL Developer Tips in 30 Days, Day 19: Quick and Clean Table Copies

thatjeffsmith SQL Developer 1 Comment

Quick and clean, what’s that? Consider the following: CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=2; I call that ‘quick and dirty,’ and I imagine you have used this technique many, many times. But, I wish it would have grabbed column comments, indexes, maybe even the partitions. Partitioning a table after the fact is pretty much a no-go. …

30 SQL Developer Tips in 30 Days, Day 10: Compare Stuff Side By Side

thatjeffsmith SQL Developer 2 Comments

We try to make comparing things easy to do. When you’re troubleshooting, you frequently need to know why A isn’t quite like B. So let’s look at a few scenarios. Execution Plans or Autotrace Runs Run a plan or autotrace. Pin it. Run another. Right-click on one, and compare with the other. Voila. Looking at Objects, Side By Side So …

An Oracle Designer Feature: Generating Table APIs with Oracle SQL Developer

thatjeffsmith SQL Developer 29 Comments

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, …