RE: Display view equations?
Date: Thu, 12 Jun 2008 12:29:00 -0400
Do you simply want the text of the view? Describe dba_views or user_views and you'll get the idea. You'll need to set "long" to at least text_length for the view in question if you want to get back all the text, and since the column is type long (at least through 10g, I don't have a running 11g at the moment to check) you'll find routine sql functions won't operate on the text column for parsing, so for a dynamic report on the formula for each column you'll probably want to either select out the text and pass it to a parser of your choice or just do the whole thing in perl (if just showing them the text isn't enough.)
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyndon Tiu
Sent: Thursday, June 12, 2008 10:01 AM
Subject: 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;
> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 12 2008 - 11:29:00 CDT