RE: USER DEFINED FUNCTIONS

Raj,

Since you are always so good (compliment) about trimming responses I'm not sure if this was aimed at Stephane, myself, or some of the other people in this thread. So, I'm going to respond in case it was to my response ;-)

Yes, UDF's have *great* value. I see first hand lot's of good uses for them, and have used them effectively. I would never discourage anyone from using them. I recommend them for consistency and simplicity of code where applicable. In some cases they *are* misused. In most cases they aren't misused but we still need to sometimes find ways to reduce *redundant* calls to them (if performance becomes an issue). And then we end up going through some hoops and writing more complex SQL to avoid the redundant calls and get maximum performance.

You mentioned fancy coding for the sake of it. I guess lots of us would like to take advantage of the latest and greatest features just to feel like we are staying on top of things. But you are so on target -- don't just use certain features because they are there. Use what is best for the situation at hand.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jamadagni,
> Rajendra
> Sent: Monday, March 11, 2002 6:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: USER DEFINED FUNCTIONS
>
>
> Agreed .... the point is as much as you can use them you can abuse them as
> well, but that shouldn't stop you from using them functions.
>
> I now see a whole lot of 'fancy coding' in the code for no reason
> at all, it
> peaked immediately after we had a new features for 8i at our place for
> developers. They end up using something just because it is available, and
> forget to do the things the easy way.
>
> some things never change
>
> Raj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  INET: elkinsl_at_flash.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).