selecting the nth value from a varray column

2002-03-13 Thread Szecsy Tamas
Hi, could someone please help me with this? I have a table where a column is of type varray of numbers. I need the 4th and 5th values that are coordinate values. How can I select only these columns` value? Every help will be highly appreciated. Tamas Szecsy -- Please see the official ORACLE-L

RE: selecting the nth value from a varray column

2002-03-13 Thread Ciprian Maftei
Hi, could someone please help me with this? I have a table where a column is of type varray of numbers. I need the 4th and 5th values that are coordinate values. How can I select only these columns` value? Every help will be highly appreciated. Tamas Szecsy -- Please see the official ORACLE-L

RE: selecting the nth value from a varray column

2002-03-13 Thread Szecsy Tamas
I give an example, just to make clear what I mean: How do I retrieve coordinate values from Oracle Spatial Object model? 1. Create a table: create table sdo (geometry mdsys.sdo_geometry); 2. Insert a record with coordinate values ( 19.135147 and 47.021199 are the coordinates) insert into sdo