Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL Humor

Re: SQL Humor

From: --CELKO-- <jcelko212_at_earthlink.net>
Date: 19 Aug 2005 08:30:35 -0700
Message-ID: <1124465435.116434.124650@g14g2000cwa.googlegroups.com>


>> just stick SSN in a varchar(20) as an extraneous attribute and use an 4 byte integer identity for foreign key relationships. <<

And sure enough, you will get a 20 letter SSN in your database. And it will be a duplicate on top of that.

A good DB designer would know to use CHAR(9) and how to write at least a minimal constraint to insure some data integrity. A good DB designer would know how to verify SSNs via several commercial and puiblic services.

But a bad DB designer does not have to bother with all that research and work. He has his proprietary, magical, universal, one-size-fits-all-creation IDENTITY column. Let's let him tell the IRS that SSNs are an "extraneous attribute" while they haul himoff to jail and close us down. Received on Fri Aug 19 2005 - 10:30:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US