怎样将ORACLE中的BLOB字段清空？

Question

update tablname set 字段=EMPTY_BLOB() where id=V_id
delete tablename where id=V_id

Answer 1

回liuyi8903(西西) ： 
能给个例子吗？谢谢

Answer 2

SQL> select * from p_jkzzblob;WELLNO               KZSX BLOBID                         JKZZBLOB BSFLAG
-------------------- ---- ------------------------------ -------- ------
4050591001              1 4050591001_K_1                 <BLOB>   1
4050591001              2 4050591001_K_2                 <BLOB>   
4050591001              3 4050591001_K_3                 <BLOB>   
4050591001              4 4050591001_K_4                 <BLOB>   
4050591001              5 4050591001_K_5                 <BLOB>   
4050591001              6 4050591001_K_6                 <BLOB>   
1086226475968           1 1086226475968                  <BLOB>   1
4050591001              7 4050591001_K_7                 <BLOB>   
1086226475968           2 1086226475968                  <BLOB>   1
3070145001              1 3070145001                     <BLOB>   110 rows selectedSQL> update p_jkzzblob set jkzzblob=EMPTY_BLOB() where wellno='4050591001';7 rows updatedSQL>