SQL> INSERT INTO THIS_XML (Client,"Date",SequenceNumber,NbMessages,version,relea
se,agency,domain,function,controlNumber,pnrPurgeDate,"number",companyId,controlN
umber2,date3,time,typeOfPnrElement,agentId,officeId,iataCode,queueingOfficeId,ci
tyCode,creationOfficeId,agentSignature,creationDate,creatorIataCode,creationTime
,quantity,status,officeId4,agentCode,receiveFrom,originatorId,inHouseIdentificat
ion1,originatorTypeCode,companyId5,locationId,codedCountry,originatorId6,inHouse
Identification17,originatorTypeCode8,companyId9,locationId10,codedCountry11,inHo
useIdentification112,originatorTypeCode13,companyId14,locationId15,codedCountry1
6,qualifier,number17,segmentName,surname,quantity18,firstName,originDestination,
qualifier19,number20,segmentName21,depDate,depTime,arrDate,arrTime,dayChangeIndi
cator,cityCode22,cityCode23,identification,identification24,classOfService,detai
l,qualifier25,date26,time27,status28,function29,companyId30,controlNumber31,quan
tity32,status33,equipment,weekDay,arrivalTerminal,departTerminal,"option",origin
atorId34,inHouseIdentification135,originatorTypeCode36,companyId37,locationId38,
codedCountry39,trueLocationId,trueLocationId40,carrierCode,flightNumber,bookingC
lass,flightIndicator,codeShareAgreement,cabinCode,subclassId,sourceQualifier1,co
untryCode,systemCode,groupingCode,marriageQualifier,tatooNum,marker2,qualifier41
,number42,segmentName43,subjectQualifier,type,longFreetext,indicator,date44,offi
ceId45,marker3,actionRequestCode)
  2  With t AS (SELECT xmltype (bfilename('MYXML','sabresample.xml.txt'), nls_ch
arset_id('WE8ISO8859P1')) xmlcol FROM dual)
  3  SELECT
  4  extractValue(value(x), '/ROW/Client') client
  5  ,extractValue(value(x),'/ROW/"Date"')"Date"
  6  ,extractValue(value(x),'/ROW/SequenceNumber')SequenceNumber
  7  ,extractValue(value(x),'/ROW/NbMessages')NbMessages
  8  ,extractValue(value(x),'/ROW/version')version
  9  ,extractValue(value(x),'/ROW/release')release
 10  ,extractValue(value(x),'/ROW/agency')agency
 11  ,extractValue(value(x),'/ROW/domain')domain
 12  ,extractValue(value(x),'/ROW/"function"')"function"
 13  ,extractValue(value(x),'/ROW/controlNumber')controlNumber
 14  ,extractValue(value(x),'/ROW/pnrPurgeDate')pnrPurgeDate
 15  ,extractValue(value(x),'/ROW/"number"')"number"
 16  ,extractValue(value(x),'/ROW/companyId')companyId
 17  ,extractValue(value(x),'/ROW/controlNumber2')controlNumber
 18  ,extractValue(value(x),'/ROW/date3')"Date"
 19  ,extractValue(value(x),'/ROW/time')time
 20  ,extractValue(value(x),'/ROW/typeOfPnrElement')typeOfPnrElement
 21  ,extractValue(value(x),'/ROW/agentId')agentId
 22  ,extractValue(value(x),'/ROW/officeId')officeId
 23  ,extractValue(value(x),'/ROW/iataCode')iataCode
 24  ,extractValue(value(x),'/ROW/queueingOfficeId')queueingOfficeId
 25  ,extractValue(value(x),'/ROW/cityCode')cityCode
 26  ,extractValue(value(x),'/ROW/creationOfficeId')creationOfficeId
 27  ,extractValue(value(x),'/ROW/agentSignature')agentSignature
 28  ,extractValue(value(x),'/ROW/creationDate')creationDate
 29  ,extractValue(value(x),'/ROW/creatorIataCode')creatorIataCode
 30  ,extractValue(value(x),'/ROW/creationTime')creationTime
 31  ,extractValue(value(x),'/ROW/quantity')quantity
 32  ,extractValue(value(x),'/ROW/status')status
 33  ,extractValue(value(x),'/ROW/officeId4')officeId
 34  ,extractValue(value(x),'/ROW/agentCode')agentCode
 35  ,extractValue(value(x),'/ROW/receiveFrom')receiveFrom
 36  ,extractValue(value(x),'/ROW/originatorId')originatorId
 37  ,extractValue(value(x),'/ROW/inHouseIdentification1')inHouseIdentification
 38  ,extractValue(value(x),'/ROW/originatorTypeCode')originatorTypeCode
 39  ,extractValue(value(x),'/ROW/companyId5')companyId
 40  ,extractValue(value(x),'/ROW/locationId')locationId
 41  ,extractValue(value(x),'/ROW/codedCountry')codedCountry
 42  ,extractValue(value(x),'/ROW/originatorId6')originatorId
 43  ,extractValue(value(x),'/ROW/inHouseIdentification17')inHouseIdentification

 44  ,extractValue(value(x),'/ROW/originatorTypeCode8')originatorTypeCode
 45  ,extractValue(value(x),'/ROW/companyId9')companyId
 46  ,extractValue(value(x),'/ROW/locationId10')locationId
 47  ,extractValue(value(x),'/ROW/codedCountry11')codedCountry
 48  ,extractValue(value(x),'/ROW/inHouseIdentification112')inHouseIdentificatio
n
 49  ,extractValue(value(x),'/ROW/originatorTypeCode13')originatorTypeCode
 50  ,extractValue(value(x),'/ROW/companyId14')companyId
 51  ,extractValue(value(x),'/ROW/locationId15')locationId
 52  ,extractValue(value(x),'/ROW/codedCountry16')codedCountry
 53  ,extractValue(value(x),'/ROW/qualifier')qualifier
 54  ,extractValue(value(x),'/ROW/number17')"number"
 55  ,extractValue(value(x),'/ROW/segmentName')segmentName
 56  ,extractValue(value(x),'/ROW/surname')surname
 57  ,extractValue(value(x),'/ROW/quantity18')quantity
 58  ,extractValue(value(x),'/ROW/firstName')firstName
 59  ,extractValue(value(x),'/ROW/originDestination')originDestination
 60  ,extractValue(value(x),'/ROW/qualifier19')qualifier
 61  ,extractValue(value(x),'/ROW/number20')"number"
 62  ,extractValue(value(x),'/ROW/segmentName21')segmentName
 63  ,extractValue(value(x),'/ROW/depDate')depDate
 64  ,extractValue(value(x),'/ROW/depTime')depTime
 65  ,extractValue(value(x),'/ROW/arrDate')arrDate
 66  ,extractValue(value(x),'/ROW/arrTime')arrTime
 67  ,extractValue(value(x),'/ROW/dayChangeIndicator')dayChangeIndicator
 68  ,extractValue(value(x),'/ROW/cityCode22')cityCode
 69  ,extractValue(value(x),'/ROW/cityCode23')cityCode
 70  ,extractValue(value(x),'/ROW/identification')identification
 71  ,extractValue(value(x),'/ROW/identification24')identification
 72  ,extractValue(value(x),'/ROW/classOfService')classOfService
 73  ,extractValue(value(x),'/ROW/detail')detail
 74  ,extractValue(value(x),'/ROW/qualifier25')qualifier
 75  ,extractValue(value(x),'/ROW/date26')"date"
 76  ,extractValue(value(x),'/ROW/time27')time
 77  ,extractValue(value(x),'/ROW/status28')status
 78  ,extractValue(value(x),'/ROW/function29')function
 79  ,extractValue(value(x),'/ROW/companyId30')companyId
 80  ,extractValue(value(x),'/ROW/controlNumber31')controlNumber
 81  ,extractValue(value(x),'/ROW/quantity32')quantity
 82  ,extractValue(value(x),'/ROW/status33')status
 83  ,extractValue(value(x),'/ROW/equipment')equipment
 84  ,extractValue(value(x),'/ROW/weekDay')weekDay
 85  ,extractValue(value(x),'/ROW/arrivalTerminal')arrivalTerminal
 86  ,extractValue(value(x),'/ROW/departTerminal')departTerminal
 87  ,extractValue(value(x),'/ROW/"option"')"option"
 88  ,extractValue(value(x),'/ROW/originatorId34')originatorId
 89  ,extractValue(value(x),'/ROW/inHouseIdentification135')inHouseIdentificatio
n
 90  ,extractValue(value(x),'/ROW/originatorTypeCode36')originatorTypeCode
 91  ,extractValue(value(x),'/ROW/companyId37')companyId
 92  ,extractValue(value(x),'/ROW/locationId38')locationId
 93  ,extractValue(value(x),'/ROW/codedCountry39')codedCountry
 94  ,extractValue(value(x),'/ROW/trueLocationId')trueLocationId
 95  ,extractValue(value(x),'/ROW/trueLocationId40')trueLocationId
 96  ,extractValue(value(x),'/ROW/carrierCode')carrierCode
 97  ,extractValue(value(x),'/ROW/flightNumber')flightNumber
 98  ,extractValue(value(x),'/ROW/bookingClass')bookingClass
 99  ,extractValue(value(x),'/ROW/flightIndicator')flightIndicator
100  ,extractValue(value(x),'/ROW/codeShareAgreement')codeShareAgreement
101  ,extractValue(value(x),'/ROW/cabinCode')cabinCode
102  ,extractValue(value(x),'/ROW/subclassId')subclassId
103  ,extractValue(value(x),'/ROW/sourceQualifier1')sourceQualifier
104  ,extractValue(value(x),'/ROW/countryCode')countryCode
105  ,extractValue(value(x),'/ROW/systemCode')systemCode
106  ,extractValue(value(x),'/ROW/groupingCode')groupingCode
107  ,extractValue(value(x),'/ROW/marriageQualifier')marriageQualifier
108  ,extractValue(value(x),'/ROW/tatooNum')tatooNum
109  ,extractValue(value(x),'/ROW/marker2')marker
110  ,extractValue(value(x),'/ROW/qualifier41')qualifier
111  ,extractValue(value(x),'/ROW/number42')"number"
112  ,extractValue(value(x),'/ROW/segmentName43')segmentName
113  ,extractValue(value(x),'/ROW/subjectQualifier')subjectQualifier
114  ,extractValue(value(x),'/ROW/type')type
115  ,extractValue(value(x),'/ROW/longFreetext')longFreetext
116  ,extractValue(value(x),'/ROW/indicator')indicator
117  ,extractValue(value(x),'/ROW/date44')"date"
118  ,extractValue(value(x),'/ROW/officeId45')officeId
119  ,extractValue(value(x),'/ROW/marker3')marker
120  ,extractValue(value(x),'/ROW/actionRequestCode')actionRequestCode
121  FROM t,TABLE(XMLSequence(extract(t.xmlcol,'/ROWSET/ROW'))) x;

0 rows created.