On Thu, Jun 12, 2008 at 7:00 AM, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote: > Any more suggestions? > > Create a small schema that contains the calculations used to create the view columns, view name, column name, etc. Create 2 small apps: 1. app to generate the views 2. app for the users to query the data used to create the view. If you stick to doing it that way, the data will always be in sync with what is in the view. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist