Info

Tech entrepreneur, executive, and investor; father of eight children; Googler.

I’ve spent the last few years largely abstracted from relational database DDL, relying on DBAs or frameworks (e.g., Hibernate) to do that for me or working with alternate persistence technologies (e.g., an XML database, Web Services, etc.).

For a quick project, I’m working with raw Oracle DDL, and I’m a little shocked at how primitive it is. Still no auto-incrementing type? Still no boolean type? Really?

Comments

3 Comments

Post a comment
  1. March 13, 2007

    I’m often amazed at how slow the commercial database vendors are to adopting features. While there is no auto-incrementing type in Oracle, using sequences will do basically the same thing. Don’t know what to tell on the boolean issue, just lame.

  2. March 13, 2007

    Joseph: Sure, sequences are the answer, I just am amazed that you have to create the sequence and then create the trigger instead of just saying the type is “AUTO_INCREMENT_LONG” or something user-friendly. I didn’t care about this eight years ago, but now its lack of inclusion is bizarre and sad.

  3. March 13, 2007

    True, I guess that I’ve been spoiled by PostgreSQL providing a SERIAL data type that does all the work of setting up the sequence for you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Basic HTML is allowed. Your email address will not be published.

Subscribe to this comment feed via RSS