因特殊需要,要向long raw字段中插入一些字符,直接insert的话,报错:
ORA-01465: invalid hex number
于是在网上搜了下,找个 rawtohex验证下:
QL>
insert
into
t_lob
values
(
'-------'
);
insert
into
t_lob
values
(
'-------'
)
*
ERROR
at
line 1:
ORA-01465: invalid hex number
SQL>
insert
into
t_lob
values
(rawtohex(
'---------'
));
1 row created.
------------------------------------------------------------------------------------------------------------
小知识点,权当给2016年开个头了,加油,2016!