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)
Received on Fri May 18 2007 - 09:43:29 CDT
