1.
SQL> desc gjh_a05 ;
Name Type Nullable Default Comments
----- ------------- -------- ------- --------
A0500 VARCHAR2(2) Y
A0501 VARCHAR2(6)
A0502 VARCHAR2(10) Y
A0503 VARCHAR2(10) Y
A0504 VARCHAR2(20) Y
A0505 VARCHAR2(255) Y
A0506 VARCHAR2(1) Y
A0507 VARCHAR2(4) Y
A0508 VARCHAR2(8) Y
A0509 CHAR(1) Y
A0510 VARCHAR2(8
declare @XML XML
SET @XML='<root>
<OLDVALUE>
<H_Action id="1130">030</H_Action>
<D_Action>030</D_Action>
<OrderCompany>00220</OrderCompany>
<OrderNumber>10004035</OrderNumber> ......
