Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to Remove Object names from pipelined output?

How to Remove Object names from pipelined output?

From: pat <armstpat_at_wellsfargo.com>
Date: 28 Jun 2005 17:45:48 -0700
Message-ID: <1120005948.357083.115640@g44g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US