Accessing array objects [message #9499] |
Sun, 16 November 2003 21:17 |
Jeffrey
Messages: 30 Registered: January 2003
|
Member |
|
|
How do i access each individual elements of an array in oracle via SQLPlus? e.g under mdsys schema, there is a sdo_ordinate_array type. How do i access its elements? Thanks!
|
|
|
|
Re: Accessing array objects [message #9549 is a reply to message #9513] |
Wed, 19 November 2003 01:38 |
Jeffrey
Messages: 30 Registered: January 2003
|
Member |
|
|
The command u just gave me is to describe the type and the size of the array. What i need here is to get the elements in the array. Like how do i get the first element/value of the array? Thanks!
|
|
|
Re: Accessing array objects [message #9578 is a reply to message #9549] |
Fri, 21 November 2003 04:18 |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
If it's an array TYPE, names, datatypes and maybe methods are all it has, so I'm not sure what you need here.
Is it a database table based on an object type, or containing columns which are nested tables?
|
|
|
Re: Accessing array objects [message #9595 is a reply to message #9578] |
Fri, 21 November 2003 20:13 |
Jeffrey
Messages: 30 Registered: January 2003
|
Member |
|
|
Actually, i am trying to write a trigger to extract the first four elements of a varray of the type NUMBER and store it into 4 individual columns after a record has been entered. So could you help me out here like how do i extract it and store it in the columns. Thanks a million.
|
|
|