RE: Display view equations?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <ltiu@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Jun 2008 10:47:24 -0400
Lyndon,
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.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lyndon Tiu
Sent: Thursday, June 12, 2008 10:01 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx 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@xxxxxxxxxxxxx>
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
> > --
> > //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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
