Thanks Jonathan. I must have been blind when I was grepping earlier. Or maybe my grep skills are lacking. I've got what I'm after now though. Thanks again. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request@xxxxxxxxxxx and include the word "subscribe" in either the subject or body. Sunday, April 3, 2005, 6:04:27 PM, Jonathan Lewis (jonathan@xxxxxxxxxxxxxxxxxx) wrote: JL> There is JL> $ORACLE_HOME/rdbms/admin/stdspec.sql JL> and stdbody.sql (used to be standard.sql in earlier JL> versions), but I suspect this is just the way in which JL> SQL builtins are made available to pl/sql, rather JL> than a complete indication of what the SQL builtins JL> can do. JL> Regards JL> Jonathan Lewis JL> http://www.jlcomp.demon.co.uk/faq/ind_faq.html JL> The Co-operative Oracle Users' FAQ JL> http://www.jlcomp.demon.co.uk/seminar.html JL> Public Appearances - schedule updated March 9th 2005 JL> ----- Original Message ----- JL> From: "Jonathan Gennick" <jonathan@xxxxxxxxxxx> JL> To: <oracle-l@xxxxxxxxxxxxx> JL> Sent: Sunday, April 03, 2005 10:08 PM JL> Subject: where to find built-in function declarations? JL> Is there any file in an Oracle installation that provides the JL> declarations to the built-in functions? For example, I'd like to see JL> how functions like CEIL are declared, and whether they are overloaded JL> to accept the newly-supported, IEEE-754 floating-point types as input. JL> Best regards, JL> Jonathan Gennick --- Brighten the corner where you are JL> http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx JL> Join the Oracle-article list and receive one JL> article on Oracle technologies per month by JL> email. To join, visit JL> http://five.pairlist.net/mailman/listinfo/oracle-article, JL> or send email to Oracle-article-request@xxxxxxxxxxx and JL> include the word "subscribe" in either the subject or body. JL> -- JL> //www.freelists.org/webpage/oracle-l JL> -- JL> //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l