Display view equations?
Date: Thu, 12 Jun 2008 06:39:39 -0700
I have a view.
The view has one field.
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.
http://www.freelists.org/webpage/oracle-l Received on Thu Jun 12 2008 - 08:39:39 CDT