Re[2]: where to find built-in function declarations?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 3 Apr 2005 21:20:25 -0400
Message-ID: <76644474495.20050403212025@gennick.com>

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@gennick.com

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_at_gennick.com and include the word "subscribe" in either the subject or body.

Sunday, April 3, 2005, 6:04:27 PM, Jonathan Lewis (jonathan_at_jlcomp.demon.co.uk) 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_at_gennick.com>
JL> To: <oracle-l_at_freelists.org>
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@gennick.com

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_at_gennick.com and
JL> include the word "subscribe" in either the subject or body.

JL> --
JL> http://www.freelists.org/webpage/oracle-l

JL> --
JL> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Apr 03 2005 - 21:24:15 CDT