Re: Display view equations?

From: Lyndon Tiu <>
Date: Thu, 12 Jun 2008 08:14:58 -0700
Message-Id: <>

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 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
Received on Thu Jun 12 2008 - 10:14:58 CDT

Original text of this message