RE: Display view equations?
Date: Thu, 12 Jun 2008 10:47:24 -0400
You can always make a private view on the user_views or user_source table showing the actual ddl for the view.
Select view_name, text from user_views would give you what you need. Create a new view for the user to query:
Create view view_ddl as select view_name, text from user_views;
Grant select on view_ddl to your users and you should be all set. You may need to grant "select" on user_views to your account to allow the view_ddl view to be created.
[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>
> > 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:
> 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 - 09:47:24 CDT