Re: Display view equations?

Thanks for the quick reply.

I need it to dynamic and not hard coded. If I change the equation in the primary view showing the results of the equation, the secondary view showing the equation must auto update.

The "1 + 2" is just a simplification of what I am doing.

The equations that go into my views are actually very complicated scientific calculations. The client wants to see the results of the equations plus the actual equations used to calculate the results.

I thought it be best to have it all dynamically (automatically) documented instead of me having to manually type the equations into a manual that may become outdated (wrong) when the equations are updated in the database views.

Any more suggestions?

On Thu, 12 Jun 2008 08:48:31 -0500 piontekdd_at_gmail.com wrote:
> how about
>
> create view test_calc_view as
> select '1 + 2' "test_col" from dual;
>
> ??
> SQL> create view test_calc_view as
> 2 select '1 + 2' "test_col" from dual;
>
> View created.
>
> SQL> select * from test_calc_view;
>
> test_
> -----
> 1 + 2
> On Thu, Jun 12, 2008 at 8:39 AM, Lyndon Tiu <ltiu_at_alumni.sfu.ca> wrote:
>
> > Hi guys,
> >
> > Hypothetical situation.
> >
> > I have a view.
> >
> > The view has one field.
> >
> > The DDL:
> >
> > create view test_view
> > as
> > select 1 + 2 "test_col" from dual;
> >
> > Now if a user does this:
> >
> > select * from test_view;
> >
> > The output is:
> >
> > test_col
> > 3
> >
> > Now I need to be able to show to user the background calculation that
> > occurs in the view. Other than explcitly indicating it in a manual, I
> > want it to show up in the database as another view.
> >
> > So that the user can select * from see_view_calculations view and see
> > something like this:
> >
> > test_view.test_col
> > 1 + 2
> >
> > Any suggestions appreciated.
> >
> > Thank you.
> >
> > --
> > Lyndon Tiu
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Bradd Piontek
> Twitter: http://www.twitter.com/piontekdd
> Oracle Blog: http://piontekdd.blogspot.com
> Linked In: http://www.linkedin.com/in/piontekdd
> Last.fm: http://www.last.fm/user/piontekdd/

--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l