Very interesting long waiting feature is available in oracle 11g, using this feature, we can define the columns in the table level and front end will retrieve the data based on the formula.

This will avoid coding in all the places of front ends especially in forms and reports. We can get consistent result in both places.

http://www.dba-oracle.com/oracle11g/oracle_11g_function_based_columns.htm