<$BlogRSDUrl$>

Thursday, September 01, 2005

Great new blog - and a counter example 

Thanks to Rob Vollman I came across oracle-wtf tonight. Inspired by the Daily-WTF its an Oracle specific what on earth were they thinking site. It should probably be read side by side with AngryDBA.

Anyhow, this little example caught my attention. Why. Well a little while ago I came across this gem in a live system.


CREATE TABLE (table name removed)
(...
"MONTH" VARCHAR2(255),
"AGE" VARCHAR2(50),
"WEIGHT" VARCHAR2(50),
"SEX" VARCHAR2(255)
...
) ;


It doesn't suffer from the problem referred to in Oracle-wtf though and that last column has humourous possibilities.

Permalink posted by Niall @ 7:36 PM
4 Comments
4 Comments:
Hmm. Must be old code. Shouldn't all the varchars be varchar2(4000) now?

- Mark
# posted by Anonymous Anonymous : 3:15 AM, September 02, 2005
 
"SEX" VARCHAR2(255)

Hmmm. There is room enough for a lot of sex...

Cheers.

Carlos.
# posted by Anonymous Anonymous : 6:59 AM, September 02, 2005
 
The larger field is for the following ;
- Sometimes
- Not Enough
- Only If I like Him/Her/It
- Someday
- In the Rear ( As was REALLY said on the Newlywed Game )
# posted by Anonymous Anonymous : 3:57 PM, September 02, 2005
 
"1 comments" still bugs me.

The word verification this time is duwhhbf.
# posted by Blogger Joel Garry : 4:16 AM, September 03, 2005
 
Post a Comment