ThatJeffSmith

Tag: DDL

Oracle SQL Developer: Configuring Object DDL Scripts

One of the more popular features in SQL Developer is the ability to generate the CREATE DDL script for any object. If you open an object editor, the SQL page shows this script. Now, what many of you don’t realize is that the way this code can be generated is configurable. The requests I am [...]

DDL Script Previews in Oracle SQL Developer Data Modeler

Data Definition Language (DDL) is used to describe an object in SQL. When you model a table in your relational model using Oracle SQL Developer Data Modeler, you are probably very curious as to the code that is being generated to represent that object. You can peek into this code using your mouse – You [...]

Visualize Your DDL Scripts

Data models sure are handy. They tell a story – how does the information get stored as data? Just what is a ‘customer?’ Sometimes though our applications die and only leave legacy scripts behind. Or maybe you are a DBA and someone has given you a set of scripts to create some new objects in [...]

Introducing the SQL Developer ‘Shopping’ Cart

Just in time for the upcoming holiday shopping season, SQL Developer v3.1 (now available as an Early Adopter release), allows the developer or DBA to build ad-hoc deployment scripts. Need to ‘order’ that list of objects and underlying data for your test environment? Just add them to your cart and you’re ready for check-out! Once [...]

You Know What Grinds My Gears? – Database Design Edition

I think one of the dirty secrets in the software business is how LITTLE feedback we get from our end-users. You know they are out there though, gritting their teeth, cursing the day someone trusted you with a keyboard and mouse. Some of this software is very expensive to boot, so one would expect these [...]

Acronyms and Assumptions

Assumptions can often get us in trouble. People don’t know what you think they know, and they know what you don’t think they know. I often present to small groups. I ask questions up front to gauge the experience level, but even so I am forced to make some assumptions. Then there are some basics [...]