Mar 252013
 
create table one_true_lookup_table (
  one_table_to_find_them integer primary key,
  one_table_to_bring_them_all varchar2(1000)
) tablespace and_in_the_darkness_bind_them;

Just like the one ring, the one true lookup table (OTLT) is a concept that should be thrown into Mount Doom

For discussions as to why the OTLT is a bad idea, have a look here, here and here.

If you enjoyed this article, Get email updates (It’s Free)

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>