I have more than 2 geographical points In USA saved in oracle DB using geometry object...
are there any function in Oracle Spatial Object that gives me the shortest route to go through all theses geographical points
Please move this question to the Oracle Spatial forum. This forum has to do with Object-Relational issues. Thanks.
You would need to create a network with all of your point geometries as nodes and lines as links. See...
Oracle® Spatial Topology and Network Data Models Developer's Guide11g Release 2 (11.2) Part II
Once you do that you can use it to solve your problem (traveling salesman).
you can use below oracle spatial functions