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