Skip to Main Content

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java code to read XML data from table

RobeenSep 15 2021

Oracle DB 12.1.0.2
Hello Team,
Is there any java code to read XML data from a table?
SQL we use XML table as shown below:

select account_link_code_n,address_type_n,account_type_v,wfl.*
from cb_address_xml,
xmltable(
'ADDRESS_DTLS'
passing ADDRESS_X
columns
ACCOUNT_TYPE varchar2(10)  path '@ACCOUNT_TYPE ',
ADDRESS_FORMAT varchar2(10) path '@ADDRESS_FORMAT',
ADDRESS_TYPE number(2) path '@ADDRESS_TYPE',
BUILDING varchar2(5) path '@CITY',
CITY varchar2(5) path '@BUILDING' ,
CITY_DESC varchar2(10) path '@CITY_DESC',
COUNTRY varchar2(10) path '@COUNTRY',
COUNTRY_DESC varchar2(10) path '@COUNTRY_DESC',
DISTRICT varchar2(10) path '@DISTRICT',
DISTRICT_DESC varchar2(10) path '@DISTRICT_DESC',
FLOOR varchar2(15) path '@FLOOR',
LANDMARK varchar2(10) path '@LANDMARK',
POSTAL_CODE varchar2(15) path '@POSTAL_CODE',
PO_CODE int path '@PO_CODE',
STREET varchar2(15) path '@STREET',
STREET_DESC varchar2(15) path '@STREET_DESC',
SUB_LOCALITY_CODE varchar2(15) path '@SUB_LOCALITY_CODE',
SUB_LOCALITY_DESC varchar2(15) path '@SUB_LOCALITY_DESC'
) wfl

Thanks,
Roshan

Comments

Post Details

Added on Sep 15 2021
0 comments
129 views