Im trying to parse xml statement for example :

"<root><AddrLn1>UNITED STATES MARSHALS OFFICE</AddrLn1><AddrLn2>MLK JR FEDERAL COURTHOUSE</AddrLn2></root>"

So I am trying to create a table and bein able to create columns and then parse the data.

I want to take the above data and insert it individually in a column on a database table. Is it possible to just make a fairly simple version of what the SQL statement code will look like?

For example >>>

Addrln1 = column in the table
inserted data = UNITED STATES MARSHALS OFFICE

From there vice versa next column would be Addrln2 = columns
Inserted data = MLK JR FEDERAL COURTHOUSE

select * 
from   xmltable('/root'
  passing 
  xmlparse(content '<root>
     <AddrLn1>UNITED STATES MARSHALS OFFICE</AddrLn1>
     <AddrLn2>MLK JR FEDERAL COURTHOUSE</AddrLn2>
  </root>')
  columns line_1 varchar2(100) path 'AddrLn1',
          line_2 varchar2(100) path 'AddrLn2');

LINE_1                         LINE_2                       
------------------------------ ------------------------------
UNITED STATES MARSHALS OFFICE  MLK JR FEDERAL COURTHOUSE