is there any way that i can see the source code for oracle built in sum() function code.
Most of the standard functions are coded in the STANDARD package. As with most of the other Oracle supplied packages the source code is wrapped so you can see what's going on.
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCA PL/SQL Developer
Oracle ACE Director
My website: oracle-base.com
My blog: oracle-base.com/blog