试试
insert into A(col1,col2,col_long) values('a','b',(select hextoraw(col_long) from B where choice....))或
insert into A(col1,col2,col_long) values('a','b',(select rawtohex(col_long) from B where choice....))
insert into A(col1,col2,col_long) values('a','b',(select hextoraw(col_long) from B where choice....))或
insert into A(col1,col2,col_long) values('a','b',(select rawtohex(col_long) from B where choice....))
WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can
only be used in a SELECT clause.
WHERE, CONNECT BY, GROUP BY, or ORDER BY clause.