By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
| XMLColumnName |
|---|
| <?xml version="1.0" encoding="utf-16"?> <data> <SchoolName>My First School</SchoolName> <Table> <TableRow RowNumber="1"> <ClassName>Maple</ClassName> <TeacherName>Jane Smith</TeacherName> </TableRow> <TableRow RowNumber="2"> <ClassName>Maple</ClassName> <TeacherName>Fred Green</TeacherName> </TableRow> <TableRow RowNumber="3"> <ClassName>Maple</ClassName> <TeacherName>Mary Peters</TeacherName> </TableRow> </Table> <Table TableId="Pupils"> <TableRow RowNumber="1"> <PupilName>David</PupilName> </TableRow> <TableRow RowNumber="2"> <PupilName>Paul</PupilName> </TableRow> <TableRow RowNumber="3"> <PupilName>Sam</PupilName> </TableRow> </Table> </data> |