Re: Display view equations?

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Thu, 12 Jun 2008 08:48:31 -0500
Message-ID: <e9569ef30806120648l7b2f7691lf7795f668e2ef2a6@mail.gmail.com>

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_at_alumni.sfu.ca> 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
> --
> http://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/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 12 2008 - 08:48:31 CDT