This discussion is archived
1 Reply Latest reply: Sep 28, 2013 9:18 AM by odie_63 RSS

need to query XML record from oracle

Faruk.m Newbie
Currently Being Moderated

hi,

 

i am new to dba.i dont know much abt xml and querying.i need to retrieve data from xml table in oracle.below my table

 

SELECT * FROM T24USR.FTN0_LD_L000 WHERE ROWNUM < 3;

 

i did this part but the output is below i couldnt get exact column value.pls help to retrieve particular column that <c4>

RECIDXMLRECORD
LD1134600447<row id="LD1134600447" xml:space="preserve">

  <c1>1083003250</c1>

  <c2>INR</c2>

  <c3>1</c3>

  <c4>1474</c4>

  <c5>IN</c5>

  <c6>20111216</c6>

  <c7>20131108</c7>

  <c8>410.01</c8>

  <c11>21056</c11>

  <c12>10000000155778</c12>

  <c13>1</c13>

  <c14>S</c14>

  <c15>1</c15>

  <c16>25.5</c16>

  <c23>NO</c23>

  <c24>14</c24>

  <c33>1</c33>

  <c38>10</c38>

  <c38 m="2">20</c38>

  <c38 m="3">21</c38>

  <c39>60</c39>

  <c39 m="2">120</c39>

  <c39 m="3">12</c39>

  <c40>20111216</c40>

  <c40 m="2">20111216</c40>

  <c40 m="3">20111216</c40>

  <c41>20111216</c41>

  <c41 m="2">20111216</c41>

  <c41 m="3">20111216</c41>

  <c42>NO</c42>

  <c42 m="2">NO</c42>

  <c42 m="3">NO</c42>

  <c44>AUTOMATIC</c44>

  <c52>TR</c52>

  <c64>NORMAL</c64>

  <c65>1</c65>

  <c67>10000000155778</c67>

  <c72>10000000155778</c72>

  <c78>10000000155778</c78>

  <c79>1715</c79>

  <c81>NO</c81>

  <c84>20111212</c84>

  <c86>IN</c86>

  <c87>IN</c87>

  <c89>AUTOMATIC</c89>

  <c90>CUR</c90>

  <c101>12000.00</c101>

  <c104>12000</c104>

  <c106>0</c106>

  <c110>100</c110>

  <c111>NO</c111>

  <c112>100</c112>

  <c113>1474.00</c113>

  <c115>NO</c115>

  <c123>10000000155778</c123>

  <c134>20111216</c134>

  <c145>NO</c145>

  <c146>NO</c146>

  <c147>AMORT</c147>

  <c159>NO</c159>

  <c160>Y</c160>

  <c167 m="14">N</c167>

  <c167 m="22">453</c167>

  <c167 m="49">6080132</c167>

  <c167 m="50">20120106</c167>

  <c167 m="52">09:30</c167>

  <c167 m="55">Y</c167>

  <c167 m="56">701</c167>

  <c167 m="60">134</c167>

  <c167 m="64">N</c167>

  <c167 m="66"/>

  <c197>NO</c197>

  <c204>1</c204>

  <c205>MID</c205>

  <c208>NO</c208>

  <c218>NO</c218>

  <c226>1</c226>

  <c233>166800002472924.01</c233>

  <c233 m="2">1-2</c233>

  <c234>Unauthorised overdraft of INR 327 on account 10000000155778.</c234>

  <c234 m="2">Unauthorised overdraft of INR 620 on account 10000000155778.</c234>

  <c236>46</c236>

  <c237>24_COB-USER</c237>

  <c237 m="2">22_COB-USER</c237>

  <c237 m="3">34_COB-USER</c237>

  <c237 m="4">41_COB-USER</c237>

  <c237 m="5">25_COB-USER</c237>

  <c237 m="6">28_COB-USER</c237>

  <c237 m="7">22_COB-USER</c237>

  <c237 m="8">45_COB-USER</c237>

  <c237 m="9">23_COB-USER</c237>

  <c237 m="10">42_COB-USER</c237>

  <c237 m="11">47_COB-USER</c237>

  <c237 m="12">29_COB-USER</c237>

  <c237 m="13">45_COB-USER</c237>

  <c237 m="14">45_COB-USER</c237>

  <c237 m="15">45_COB-USER</c237>

  <c237 m="16">46_COB-USER</c237>

  <c237 m="17">46_COB-USER</c237>

  <c237 m="18">21_COB-USER</c237>

  <c237 m="19">33_COB-USER</c237>

  <c237 m="20">48_COB-USER</c237>

  <c237 m="21">50_COB-USER</c237>

  <c237 m="22">52_COB-USER</c237>

  <c237 m="23">30_COB-USER</c237>

  <c237 m="24">52_COB-USER</c237>

  <c237 m="25">52_COB-USER</c237>

  <c237 m="26">46_COB-USER</c237>

  <c237 m="27">55_COB-USER</c237>

  <c237 m="28">34_COB-USER</c237>

  <c237 m="29">27_COB-USER</c237>

  <c237 m="30">34_COB-USER</c237>

  <c237 m="31">59_COB-USER</c237>

  <c237 m="32">51_COB-USER</c237>

  <c237 m="33">55_COB-USER</c237>

  <c237 m="34">44_COB-USER</c237>

  <c237 m="35">55_COB-USER</c237>

  <c237 m="36">51_COB-USER</c237>

  <c237 m="37">58_COB-USER</c237>

  <c237 m="38">35_COB-USER</c237>

  <c237 m="39">31_COB-USER</c237>

  <c237 m="40">32_COB-USER</c237>

  <c237 m="41">57_COB-USER</c237>

  <c237 m="42">53_COB-USER</c237>

  <c237 m="43">59_COB-USER</c237>

  <c237 m="44">55_COB-USER</c237>

  <c237 m="45">61_COB-USER</c237>

  <c237 m="46">4_COB-USER___OFS_LD.OFS.INPUT</c237>

  <c238>1308312015</c238>

  <c239>4_COB-USER_OFS_LD.OFS.AUTH</c239>

  <c240>IN0011083</c240>

  <c241>1</c241>

</row>

 

Regards

faruk

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points