Re: Decomposing xml into table

[Thomas Kellerer]

Surafel Temesgen schrieb am 23.06.2020 um 13:59:
>> Did you try the xmltable function?
>
> yes i know it  but i am proposing changing given xml data in to
> relational form and insert it to desired table at once
Well, xmltable() does change the XML data to a relational form and
the result can directly be used to insert into a table

   insert into target_table (...)
   select ...
   from xmltable(...);