Oracle及DB2显示字符16进制信息

SP2-0784:返回的以 0xE7 开头的字符无效或不完整

db2>

selectlength(RQINVCNO) from  ecds.ecdsnodt0206where CDNO='131033300002920151125036199091';

selectRQINVCNO from  ecds.ecdsnodt0206 whereCDNO='131033300002920151125036199091';

db2"select hex(RQINVCNO) from ecds.ecdsnodt0206 where CDNO='131033300002920151125036199091'";

 

SQL>

selectdump(RQINVCNO, 16) LNAME_hex

               from ecds.ecdsnodt0206 whereCDNO='131033300002920151125036199091';

          

selectutl_raw.cast_to_varchar2( utl_raw.cast_to_raw(RQINVCNO)) From ecds.ecdsnodt0206where CDNO='131033300002920151125036199091';

selectutl_raw.cast_to_raw(RQINVCNO) From ecds.ecdsnodt0206 whereCDNO='131033300002920151125036199091';

selectutl_raw.cast_to_raw(RQINVCNO) From ecds.ecdsnodt0206 whereCDNO='190745200001620151123035924403';