...so that the application doesn't have to go into the PL/SQL tables every time?I'm not sure what you mean by this. If you have a small table that will contain often-queried lookup data, then creating the table with the CACHE clause and no index is possible. When the table is first queried, it will perform a full-table scan into the DB Block buffer cache. The CACHE clause changes the default behavior such that the blocks don't get aged out quickly. Subsequent queries will pull the data from memory rather than disk so long as it remains cached.