Paul wrote:
> Thanks for the response Tony, I thought I had tried this but obviously
> not in the correct way. I now have another issue. The function is not
> deterministic and so cannot be indexed. However, I read that you can
> just tell Oracle the function is deterministic and so I have done this
> and everything appears fine. I am not too happy about this solution
> though.
>
> Does anybody have any thoughts on this?
It means that Oracle will assume the function is deterministic, and so
will happily return "old" table2 descriptions even if table2 has been
updated. If you really don't mind returned descriptions being possibly
wrong then go ahead...
Received on Thu Oct 13 2005 - 08:19:28 CDT
