Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'Big' doubt...
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu May 17 2007 - 20:58:57 CDT
![]() |
![]() |