Display view equations?

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
--

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