CASE Statement

Using DB 9i and Developer 10g

I have a table that holds all of the transaction information resulting from adds, updates and deletions in all the tables that make up my application.

Many of the values that are stored in the table are the identification number for the item instead of the human readable name for the item.

I have created a form that displays the transaction information for the item selected. The form displays the table name, column name, old value, new value, how the column was manipulated (update, insert, delete), user name, date of transaction, etc..

Many of the values that are recorded in this transaction table are the identification number that is associated to an item and not the item name.