RE: Display view equations?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <ltiu@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Jun 2008 12:03:03 -0400
Lyndon,
You wanted something dynamic and simple. What you are now saying is
that you want something easily readable. These might be opposites!
I think you probably need to bite the bullet and produce formal readable
documentation that you will keep up to date for the users to easily
read!
Sorry.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lyndon Tiu
Sent: Thursday, June 12, 2008 11:15 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Display view equations?
Thank you for your suggestion.
I have looked into this and it looks promising. The issue I have with
this is that the DDL is not exxactly user friendly (as in non-SQL user
friendly). We are talking about scientific type folks here who 'could'
decipher SQL DDL but would rather have the equation displayed clearly
out in-front and not have to read SQL.
Could I somehow easily break up the looong DDL statements stored in the
user_views and user_source table and display the equation 'nuggets' one
by one instead of the whole SQL DDL line?
Any other suggestions?
On Thu, 12 Jun 2008 10:47:24 -0400 Thomas.Mercadante@xxxxxxxxxxxxxxxxx
wrote:
> 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
--
Lyndon Tiu
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
