Display view equations?

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Thu, 12 Jun 2008 06:39:39 -0700
Message-Id: <200806121339.m5CDddkw026507@rm-rstar.sfu.ca>

Hi guys,

Hypothetical situation.

I have a view.

The view has one field.

The DDL:

create view test_view
select 1 + 2 "test_col" from dual;

Now if a user does this:

select * from test_view;

The output is:


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:

1 + 2

Any suggestions appreciated.

Thank you.


Lyndon Tiu

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 12 2008 - 08:39:39 CDT

Original text of this message