Re: Display view equations?
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: ltiu@xxxxxxxxxxxxx
- Date: Thu, 12 Jun 2008 08:48:31 -0500
how about
create view test_calc_view as
select '1 + 2' "test_col" from dual;
??
SQL> create view test_calc_view as
2 select '1 + 2' "test_col" from dual;
View created.
SQL> select * from test_calc_view;
test_
-----
1 + 2
On Thu, Jun 12, 2008 at 8:39 AM, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote:
> 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
>
>
>
--
Bradd Piontek
Twitter: http://www.twitter.com/piontekdd
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
Last.fm: http://www.last.fm/user/piontekdd/
Other related posts:
