Valentin Minzatu wrote:
> On May 17, 9:58 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> Valentin Minzatu wrote:
>>> Can you add a view on top of the table and hide the transformation
>>> logic behind it?
>> Only with an extraordinarily inefficient view such as one built like
>> this:
>>
>> CREATE VIEW v AS
>> SELECT function_call(param), function_call(param)
>>
>> I would suggest looking at using a pipelined table function instead.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> I was thinking more on the lines of a view like:
> CREATE VIEW v AS
> SELECT id, TRANSLATE(name, ' ', '-')
> FROM <original_table>
> (my understanding is the application code cannot be changed, otherwise
> there is no need for a view)
Define "hide the transformation logic." You seem to mean something very
different than I assumed.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri May 18 2007 - 10:35:08 CDT
