I need to load an xml file in Aster Database
I need to use functions like XMLParser OR XMLRelation.
But both the above functions need a table as input. So how do I get this xml file into a table
I know I am late to answer this question.
But hopefully, this will help people in future.
1. Create a table
CREATE TABLE TEST( xid int, xml varchar);
2. Format the xml file into a single line using following cmd on linux -