On 04/03/2005 05:08:49 PM, Jonathan Gennick wrote:
> Is there any file in an Oracle installation that provides the
> declarations to the built-in functions?=20
Jonathan, on 10g declarations are in $ORACLE_HOME/rdbms/public
in *.h files. Here is what I found for the CEIL function:
$ nm $ORACLE_HOME/bin/oracle|grep -i ceil
0b69c544 d _CEIL_
U ceil@@GLIBC_2.0
0a86008e T getTRACEILP
0b03aede T lpxxpceiling
0a3a3884 T OCINumberCeil
0a8600ca T setTRACEILP
0a0971f2 T slfpdceil
0a096ce0 T slfpfceil
$
$ cd rdbms/public
$ grep -i ceil *.h
occiData.h: const Number ceil() const ;
orl.h: OCINumberCeil - OCINumber CEiling of number
orl.h:#define OCINumberCeil orlncel
orl.h:/*---------------------------- OCINumberCeil ------------------------=
--------*/
orl.h:sword OCINumberCeil( OCIError *err, CONST OCINumber *number,
orl.h: NAME: OCINumberCeil - OCINumber compute the CEiL value of an Oracl=
e number
orl.h: result (OUT) - output which will contain the ceil value of th=
e
orl.h: Computes the ceil value of an Oracle number.
--=20
Mladen Gogala
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
