Skip to Main Content
Forums

SQL & PL/SQL

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!

Need inputs to extract XML values in a single SQL Query

VisuMay 29 2017 — edited May 31 2017

Hi All,

I got the attached XML file as per the requirement, In that XML file I need to pickup Employee Number, Full_name, Location_name and Location_id as separate columns.

My Expected Output

---------------------

    

Employee NumberFull NameLocation NameLocation Id
672Hunter1, Ian1Redwood City300000047013170
670Zeigler2, Dianne2Chicago300000047013180

Kindly suggest how extract XML tag values in a single SQL query. As I need to use same SQL query in Fusion Cloud.

Thanks,

Visu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2017
Added on May 29 2017
13 comments
1,477 views