Developer’s Toolbox

Database Applications Development
| Jan 31, 2012 06:00 +0000

I had the privilege to be a guest blogger on the ODTUG blog. I wrote about Kscope and my role in putting together the Developer’s Toolbox track as well as why you should attend Kscope. Here is a short excerpt:

This year’s Kscope is a special one t…

Interesting Bug

Database Applications Development
| Jan 24, 2012 10:58 +0000

Michael posted a comment on Martin’s blog, that I previously quoted, about a “hack” to add a comment on a default value definition. Here is an example of how it works (tested in 11.2.0.1):

SQL> CREATE TABLE t (
2 x VARCHAR2 (10) DEF…

Comments on Constraints and Indexes in the Database, a Good Idea?

Database Applications Development
| Jan 24, 2012 09:57 +0000

Martin Widlake thinks so:

Comments are great, you can put 4000 characters of information into the database about each table, view and column. This can be a brief description of the object, a full explanation of what a column is to hold or even a list …