11,997 reputation
11833
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 7 months
seen 1 hour ago
Oracle ACE

Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jun
8
awarded  Caucus
Jun
8
answered Is there such thing as automatic ENUMs?
Jun
6
answered How can I get the Oracle TNSListener to start after changing my host name?
May
23
answered Return many rows on a plsql Oracle10g
May
23
revised SQL substitution feature in Oracle 10g
added 2326 characters in body
May
23
answered SQL substitution feature in Oracle 10g
May
15
answered Filter On Indexed, Formatted DATE
May
14
answered Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
May
8
revised Oracle extents - How can I have so few with this large size?
edited body
May
8
comment Database design problem: where to put UNIQUE constraint
@ypercube - Yes, that was my mistake. Fixed my answer.
May
8
revised Database design problem: where to put UNIQUE constraint
deleted 1 characters in body
May
8
answered Database design problem: where to put UNIQUE constraint
May
8
comment Database design problem: where to put UNIQUE constraint
Is there really a many-to-may relationship between forms and blocks? One block can appear on multiple forms? If there is a many-to-many relationship, should the orderInForm be for a particular form? Or should it apply to all forms?
May
8
answered Oracle extents - How can I have so few with this large size?
May
8
comment oracle sql dependency extractor
@MK01 - But why do the objects need to be created dynamically? Why can't you populate existing objects? Could the SQL scripts be converted into stored procedures?
May
7
comment Is commit necessary after DML operation in Function/Procedure?
@Phil - True, but that's a very different animal. An autonomous transaction cannot see the uncommitted changes made by the caller and cannot be rolled back by the caller so it is extremely unlikely that anything other than a logging procedure ought to be declared to use an autonomous transaction.
May
7
answered Oracle extents - How can I have so many with this small size?
May
7
awarded  Nice Answer