Display view equations?
- From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 12 Jun 2008 06:39:39 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
