How to Generate XML of two Note and Note Items Tables Hierarchically

Question

Staff would like to create the XML of two tables Imagine an example below

CREATE TABLE T_PARENT (ID NUMBER, TOTAL_VALUE NUMBER, LOCAL_OPERATION VARCHAR2(100), AGENT_OPERATOR VARCHAR2(50), BANK_OPERATOR VARCHAR2(10), CONSTRAINT T_parent_pk PRIMARY KEY (ID) ); CREATE TABLE T_CHILD (ID_CHILD NUMBER, ID_PARENT NUMBER, VALUE_OPERATION NUMBER, QTD_OPERATION NUMBER, CONSTRAINT T_child_pk PRIMARY KEY (ID_CHILD), CONSTRAINT fk_ID FOREIGN KEY (ID_PARENT) REFERENCES T_PARENT(ID));

INSERT INTO T_PARENT (id,total_value,Local_Operation,Agent_Operator,bank_operator) VALUES (1,1000,'PORTUGAL','SOARES','BBV');
INSERT INTO T_PARENT VALUES (2,200,'ENGLAND','BLAIR','BBA');               

Insert into t_child values(1,1,200,1); Insert into t_child values(2,1,200,3); Insert into t_child values (3,1,100,1); Insert into t_child values(4,1,100,1); Insert into t_child values(5,2,50,2); Insert into t_child values(6,2,100,1);

I would like it to be displayed like this, first data from the Parent table (T_PARENT) and their respective children (T_CHILD), but columns Alphabetically SOARES BBV 1 PORTUGAL 1000 1 1 1
200 1 1 1 200 2 1 3 200
3 1 1 100 4 1 1 100
BLAIR
BBA 2 ENGLAND 200
5 2 2 50

6 2 1 100