SQL & PL/SQL

Hi All ,

iam facing issue to generate the parent tag in xml

i fetch the records from excel csv file with common delimiter i have successfully generated the xml file but parent tag is repeat

with child records that my issue

1)csv file(EMP_TEST.csv) excel

EMPNO ENAME HIREDATE SAL   COMM

1     subbu 20150923 100.2 20

2     raja   20150923 20.2 20

3     surekha 20150923 2000 20

xml generate with my code

2) EMP_TEST.xml

<EMPLOYEE>

<EMPLOYEE><SLRNO>1</SLRNO><Payment_Code>CHK</Payment_Code><EMPNO>1</EMPNO><Hiredate>09/23/2015</Hiredate><Sal>100.2</Sal><COMM>20

</COMM><Revised_Document_Status>V</Revised_Document_Status><Document_Status_Revision_Reason_Code>VR9</Document_Status_Revision_Reason_Code>

<Document_Status_Revision_Description></Document_Status_Revision_Description></EMPLOYEE></EMPLOYEE>

<EMPLOYEE><EMPLOYEE><SLRNO>2</SLRNO><Payment_Code>CHK</Payment_Code><EMPNO>2</EMPNO><Hiredate>09/23/2015</Hiredate><Sal>20.2</Sal><COMM>20

</COMM><Revised_Document_Status>V</Revised_Document_Status><Document_Status_Revision_Reason_Code>VR9</Document_Status_Revision_Reason_Code><Document_Status_Revision_Description></Document_Status_Revision_Description></EMPLOYEE></EMPLOYEE>

<EMPLOYEE><EMPLOYEE><SLRNO>3</SLRNO><Payment_Code>CHK</Payment_Code><EMPNO>3</EMPNO><Hiredate>09/23/2015</Hiredate><Sal>2000</Sal><COMM>20

</COMM><Revised_Document_Status>V</Revised_Document_Status><Document_Status_Revision_Reason_Code>VR9</Document_Status_Revision_Reason_Code><Document_Status_Revision_Description></Document_Status_Revision_Description></EMPLOYEE></EMPLOYEE>

as my requirement parent tag only once like these <EMPLOYEE><EMPLOYEE><EMPNO>1</EMPNO>..</EMPLOYEE>

                                                            <EMPLOYEE><EMPNO>1</EMPNO>..</EMPLOYEE>..

                                                  </EMPLOYEE>

actual my code fetch single records write into the xml file can please suggeste me any thing for these

thanks

subbu