Subject | selectable SP vs UDF |
---|---|
Author | Bambang P |
Post date | 2005-10-06T14:29:44Z |
Instead of using UDF, as long as possible, I prefer to use
selectable SP than UDF. So, for example, I'd rather write:
select (select RESULT from IS_FRIDAY(CLASS_DATE))
from PRESENCE;
instead of
select IS_FRIDAY(CLASS_DATE) of PRESENCE;
Is it an acceptable practice? Is there any disadvantages of this technique?
--
Bambang P.
selectable SP than UDF. So, for example, I'd rather write:
select (select RESULT from IS_FRIDAY(CLASS_DATE))
from PRESENCE;
instead of
select IS_FRIDAY(CLASS_DATE) of PRESENCE;
Is it an acceptable practice? Is there any disadvantages of this technique?
--
Bambang P.