Mic777
Junior Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Код: select RqUID,
to_date(OrigDtD || '.' || OrigDtM || '.' || OrigDtY, 'dd.mm.yyyy') as OrigDt,
to_date(DueDtD || '.' || DueDtM || '.' || DueDtY, 'dd.mm.yyyy') as DueDt
from XMLTABLE('$p/FDX/BankSvcRq/XferAddRq'
passing XMLTYPE('<?xml version="1.0" encoding="windows-1251"?>
<?fdx version="1.0"?>
<FDX>
<SignonRq>
<SignonPswd>
<CustId>
<SPName>XML Bus</SPName>
<CustLoginId>RS_RUST1</CustLoginId>
</CustId>
<CustPswd>
<CryptType>None</CryptType>
<Pswd>Client System Password</Pswd>
</CustPswd>
</SignonPswd>
<ClientDt>
<Year>2016</Year>
<Month>2</Month>
<Day>3</Day>
<Hour>0</Hour>
<Minute>43</Minute>
<Second>12</Second>
<UTCOffset>0</UTCOffset>
</ClientDt>
</SignonRq>
<BankSvcRq>
<RqUID>78EE0C00530A1450FBA3756A700D0078</RqUID>
<XferAddRq>
<RqUID>78EE0C00530A1450FBA3756A700D0078</RqUID>
<XferInfo>
<BankAcctIdFrom>
<AcctId>46546285863166</AcctId>
<AccCl>86566004556456</AccCl>
<BankInfo>
<BankIdType>BIC</BankIdType>
<BankId>5645821</BankId>
<RUS.CorrAcct>3006841158416696</RUS.CorrAcct>
</BankInfo>
</BankAcctIdFrom>
<NameFrom>Иванов Сергей Петрович</NameFrom>
<TaxIdFrom>0</TaxIdFrom>
<BankAcctIdTo>
<AcctId>89423810000889200520</AcctId>
<AccCl>89423810000889200520</AccCl>
<BankInfo>
<BankIdType>RUS.BIC</BankIdType>
<BankId>514450521</BankId>
<RUS.CorrAcct>01530810008452501101</RUS.CorrAcct>
</BankInfo>
</BankAcctIdTo>
<NameTo>Иванов Сергей Петрович</NameTo>
<TaxIdTo>0</TaxIdTo>
<TaxRegCodeFrom></TaxRegCodeFrom>
<TaxRegCodeTo></TaxRegCodeTo>
<CurAmt>
<Amt>600.00</Amt>
<CurCode>RUB</CurCode>
</CurAmt>
<OrigDt>
<Year>2016</Year>
<Month>2</Month>
<Day>3</Day>
</OrigDt>
<DueDt>
<Year>2016</Year>
<Month>3</Month>
<Day>3</Day>
</DueDt>
<TrnCode>108</TrnCode>
<AdvType>11</AdvType>
<PriorityPmt>2</PriorityPmt>
<PmtId></PmtId>
<Purpose></Purpose>
<AdvNum>22518</AdvNum>
<RegistryNum>097</RegistryNum>
<CSRCode>028</CSRCode>
</XferInfo>
</XferAddRq>
</BankSvcRq>
</FDX>') as "p"
COLUMNS
RqUID varchar2(32) path 'RqUID',
OrigDtY varchar2(4) path 'XferInfo/OrigDt/Year',
OrigDtM varchar2(2) path 'XferInfo/OrigDt/Month',
OrigDtD varchar2(2) path 'XferInfo/OrigDt/Day',
DueDtY varchar2(4) path 'XferInfo/DueDt/Year',
DueDtM varchar2(2) path 'XferInfo/DueDt/Month',
DueDtD varchar2(2) path 'XferInfo/DueDt/Day'
);
|
|
Всего записей: 90 | Зарегистр. 15-12-2005 | Отправлено: 10:00 06-10-2017 | Исправлено: Mic777, 10:26 06-10-2017 |
|
