xmltype in oracle inserting problem

See more:

Oracle

Hi All,

Can you please help me anybody on this .i am uploading excel sheet data converted into xml file from dataset and inserting into oracle DB, while inserting record is like this .

Input record in sheet is like this : R3 UAT Jia Yang3.4 - Specical Characters Load"',

after inserting recodr into Table its showing like this ;R3 UAT Jia Yang3.4 - Specical Characters Load"',

please help me how to avoid this while inserting to table i want what ever is there in sheet same values i need to insert into table.



Regards,
Narasimha