Subject | Re: Stored Procedure vs View for derived/calculated data |
---|---|
Author | Paco Zárate |
Post date | 2003-01-13T18:01:24Z |
[...
]> One interesting aspect (at least for me...:) that I encountered is
that
Hmmm maybe you could use the next construction:
select mt.record_id, (select somevalue from calc_value
(mt.record_id)) from myTable mt;
The "somevalue" field is the one that you put in the returns section
of the store procedure.
Regards
Paco Zarate
]> One interesting aspect (at least for me...:) that I encountered is
that
> with the CALC_ONE style, I expected to write something like :Hi Sugi:
> ...
> select mt.record_id, calc_one(mt.record_id)
> from myTable mt;
> ...
> which is very intuitive, but would not work....:)
>
Hmmm maybe you could use the next construction:
select mt.record_id, (select somevalue from calc_value
(mt.record_id)) from myTable mt;
The "somevalue" field is the one that you put in the returns section
of the store procedure.
Regards
Paco Zarate