Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
select on multivalue xml column

Hi all,
this is my first question on the oracle community forum, so thanks in advance for you help .
i have a database with some xml tables where there is few multivalues columns with different number set of values on each one, some times we could have just one value (which is the minimum) and some times more than one (2, 3 4 ...).
i need to select all multivalues available on this column for each id
for example if the ID XYZ contains 2 values on column 6 the query will return those two values, if its 3 ...
example of query that i am using now to extract values one by one :
select ID, extractValue(xmlrecord,'/row/c10[position()=1]') from MY_TABLE where recid = 'MY_REC_ID;
my data is stored like bellow example inside the xml column
<row id='MY_RECORD_ID'><c3>0</c3><c4>F</c4><c6>MY_DATA1</c6><c6 m='2'>MY_DATA_2</c6><c7></c7><c7 m='2'>OTHER_DATA</c7><c8>D</c8><c8 m='2'>D</c8><c9 m='2'></c9><c10 m='2'></c10><c11>OTHER_DATA3</c11><c11 m='2'></c11></row>
thank you for your help