SQL & PL/SQL

hi, im sure someone will probably know this quickly.

Im generating some xml in oracle, one of the nested queries is similiar to this..

select  test1 
          ,test2
           ,  xmlelement
                ( "QUESTION"
                , xmlattributes ( question_n as "question_number",question as "question_t")  
              
             
                ) AS Xt1 
        FROM  myview_VW  

but for some reason in my end result the order of the questions are always messed up , is there a way to keep the attribute order ?


i have tried an order by here, but this query is nested in many others. like I said i basically want to just keep the order.

select  test1 
          ,test2
           ,  xmlelement
                ( "QUESTION"
                , xmlattributes ( question_n as "question_number",question as "question_t")  
              
             
                ) AS Xt1 order by question_n
        FROM  myview_VW  

I know i did not include any build code, if that is needed I will

thank you