Re: where to find built-in function declarations?
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 3 Apr 2005 23:04:27 +0100
There is
$ORACLE_HOME/rdbms/admin/stdspec.sql
and stdbody.sql (used to be standard.sql in earlier
versions), but I suspect this is just the way in which
SQL builtins are made available to pl/sql, rather
than a complete indication of what the SQL builtins
can do.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated March 9th 2005
----- Original Message -----
From: "Jonathan Gennick" <jonathan@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, April 03, 2005 10:08 PM
Subject: where to find built-in function declarations?
Is there any file in an Oracle installation that provides the
declarations to the built-in functions? For example, I'd like to see
how functions like CEIL are declared, and whether they are overloaded
to accept the newly-supported, IEEE-754 floating-point types as input.
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
