Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to Remove Object names from pipelined output?
I have an export routine the exports huge amounts of data with xml
tags. I've used pipeline to reduce resource usage,but the object names
are displayed in the output. I need to remove these object names. A
sample of my output is below.
SQL> select somePackage.fct from dual;
EXTRACTTABLETABLE(EXTRACTTABLE(EXTRACTROW(1,
'<record><timestamp>1119904208950</ timestamp><field1>field
one</field1><field2>field2</field2>
<field3>field3 <field3><field4>recordversion<field4><field5>
field5</field5><field6>field6</field6><field7>1119904208950</field7>
<field8>111 9904209150</field8>'), EXTRACTROW(2,
'<property><key>exHXyZteUkymitqzWgkGAnNPJb ixglES
</key><value>DVfAInMEDJRcrhtPbJTzAxQeIqSTjjdsFgKqskHk</value></property>')
, EXTRACTROW(3, '<property>
<key>lWNkhSncISoFCnxvopELCvGmpZijgxtI</key><value>CSX
kIXrKTheaPWQTLGSUlecvnpZoCWWwkARkzkXC</value></property>'),
EXTRACTROW(4, '<property>
<key>JsHueOsaXdWejjPczAWeLeKVxCatpQrc</key><value>GPNYdIBvYIJUSCieiXnWJdOAU
WeDEWoFyROObDkZ</value></property>'), EXTRACTROW(5, '<property>
<key>avuNFcxRjLiO
AkTzKgTXCcJHzvfCJXyL</key><value>PEaaUgVIMzUYyczILvrGhfzeryAFyzUATJwkVEsT</value
></property>'), EXTRACTROW(6, '<property>
<key>qFyYaXJmMOOCHzkPTPOCwlzGaaSHnDwB</
key><value>sDXZfsMEfHRuUzbjKtzPFWCjiQhkpIjhIdMSnkwd</value></property>')
Received on Tue Jun 28 2005 - 19:45:48 CDT