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: Stupid Database Tricks

Re: Stupid Database Tricks

From: x <x-false_at_yahoo.com>
Date: Tue, 22 Jun 2004 17:25:36 +0300
Message-ID: <40d84064@post.usenet.com>

"Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote in message news:cb9bko$kmv$1_at_news.netins.net...

> 22. If you need a new attribute for an application, find one that isn't
> used anymore and just reuse it even if the name doesn't match.

22'. If there isn't such a column, pick one of the existing less used columns, preferable of string type, and just use an encoding scheme. This will minimize the number of columns and datatype used.

22''. Only for the connoisseur: Just use one variable string field/record.

22'''. For the experts: Just use one variable string.

22''''. For the genius: Just use a circular string because it has no ends.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Tue Jun 22 2004 - 09:25:36 CDT

Original text of this message

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