| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Stupid Database Tricks
"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.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
![]() |
![]() |