Skip to content

Author Archives Eddie Awad

Developer’s Toolbox

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 to me. I volunteered to lead the Developer’s [...]

Posted 31 January 2012 § Oracle § Uncategorized ‡ Comments Off °

Interesting Bug

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) DEFAULT ‘Hi’ — There. This will be stored too. 3 ); Table [...]

Posted 24 January 2012 § Oracle § Uncategorized ‡ Comments Off °

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

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 of typical entries for a column or table. But [...]

Posted 24 January 2012 § Oracle § Uncategorized ‡ Comments Off °