Jorge,
I've not used it, but the Oracle training manual says this:
"The SDO_GEOM.SDO_LENGTH function is an overloaded function that calculates
the length of a line segment or the length of the perimeter of a polygon.
The first parameter is an object of type SDO_GEOMETRY. This object can come
from a table, a variable, a constructor, or it can be the result of another
function that returns an SDO_GEOMETRY object.
The second parameter is the data tolerance.
Optionally, a third parameter specifies the UNIT for the results. This is
formatted within a quoted string, for example, 'UNIT=FOOT' or 'UNIT=METER'.
There are many different values allowed for the UNIT distance parameter,
although some values have the same meaning (for example, KM and KILOMETER).
A list of supported values for the UNIT parameter is available by running
the following query:
select sdo_unit from mdsys.sdo_dist_units;
Note: Tolerance is not used in the length calculation."
Example:
SELECT highway,
SDO_GEOM.SDO_LENGTH (geom, 0.5,'unit=kilometer')
FROM geod_interstates
WHERE highway = 'I195';
There are many other functions in SDO_GEOM, and I expect that these are
detailed on the Oracle website.
Regards,
Keith
-----Original Message-----
From: Jorge Picoaga Ortecho Picoaga [mailto:[EMAIL PROTECTED]
Sent: 11 June 2005 20:39
To: [email protected]
Subject: MI-L Problems with oracle9i package
Hi everybody...I am working with Mapinfo and Oracle spatial and I dont know
to use the package SDO_GEOM ,inside of this package there is a function
SDO_LENG that I dont know to use, someone can give me a example of this
package and how can I to use?...
Thanks a lot...
Jorge Picoaga Ortecho
Lima Peru
> --- Urspr�ngliche Nachricht ---
> Von: Jes�s Orozco <[EMAIL PROTECTED]>
> An: Richard Nilsson <[EMAIL PROTECTED]>
> Kopie: "[email protected]"
> <[email protected]>
> Betreff: Re: MI-L Problems hotlinking to a html-anchor
> Datum: Fri, 10 Jun 2005 18:44:08 +0200
>
> Hi,
>
> I don't know if you copy-pasted file:// instead of file:///
>
> If I have a index.html file in my C:\ path, I would make a link to it
> as: file:///C:/index.html
>
> Hope this helps
> Jes�s
>
> Richard Nilsson wrote:
>
> >Hello!
> >
> >I have a problem that I've spent a whole day trying to solve. It
> >concerns hotlinking to an anchor in a htmlfile (somefile.htm#anchor).
> >This works just fine when I link to a webbased htmlfile
> >(http://www.someserver.com/somefile.htm#anchor
> ><http://www.someserver.com/somefile.htm> ), but when I try to link to
> >an anchor in a htmlfile on my harddrive (file://G:\hoorsan.htm#006)
> >something goes wrong! The statusbar in MI shows the whole link,
> >including the anchor, but when the file opens in Internet explorer
> >the anchor somehow gets cut off (file://G:\hoorsan.htm#006 becomes
> >file://G:\hoorsan.htm) and I end up at the top of the page instead of
> >further down at the anchor where I wanted to go! Does anyone have a
> >solution or explanation for this?
> >
> >I am running Mapinfo Pro 7.0 on Win XP Pro SP 1.
> >
> >Thanks in advance!
> >
> >/Richard
> >
> >
> >
> >---------------------------------------------------------------------
> >List hosting provided by Directions Magazine | www.directionsmag.com
> >| To unsubscribe, e-mail:
> >[EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >Message number: 16779
> >
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> Message number: 16780
>
--
Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis
++ Jetzt anmelden & testen ++ http://www.gmx.net/de/go/promail ++
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16783
This message has been scanned for viruses by MailControl - (see
http://bluepages.wsatkins.co.uk/?4318150)
This email and any attached files are confidential and copyright protected. If
you are not the addressee, any dissemination of this communication is strictly
prohibited. Unless otherwise expressly agreed in writing, nothing stated in
this communication shall be legally binding.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16787
