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(...);