十进制转换为十六进制
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+1),'XXXXXXXXXXXXX'),3,12) mac2,
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+2),'XXXXXXXXXXXXX'),3,12) mac3,
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+3),'XXXXXXXXXXXXX'),3,12) mac4,
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+4),'XXXXXXXXXXXXX'),3,12) mac5
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+1),'XXXXXXXXXXXXX'),3,12) mac2,
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+2),'XXXXXXXXXXXXX'),3,12) mac3,
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+3),'XXXXXXXXXXXXX'),3,12) mac4,
substr(TO_CHAR(to_char(to_number('F'||c.extend1,'xxxxxxxxxxxxxxxxxxxxxx')+4),'XXXXXXXXXXXXX'),3,12) mac5