Re: Display view equations?
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 12 Jun 2008 10:08:47 -0700
Message-ID: <bf46380806121008t47d3726o294b7ae4541713be@mail.gmail.com>
Date: Thu, 12 Jun 2008 10:08:47 -0700
Message-ID: <bf46380806121008t47d3726o294b7ae4541713be@mail.gmail.com>
On Thu, Jun 12, 2008 at 7:00 AM, Lyndon Tiu <ltiu_at_alumni.sfu.ca> 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:
- app to generate the views
- 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 12 2008 - 12:08:47 CDT