Hello.
I've started using Oracle Spatial and need to create a view getting points from two related and show a line connecting them.
I found many articles showing how to create lines from an array of points, but none explaining how to get one geometry from table a and one from table b and create a line between them.
The tables change with some frequency, so it's out of question create the lines at a GIS and upload them.
Thanks
E. Barbara