这种方式比较繁琐,lob包里面没发现这种功能的函数
不知有没有更好的方式
12:09:03 SQL> select * from tlob; AAA BBB
--------- ---------------------------------------------------------------------
1 asdfasdf
1 tstfifof;fff]v]
1 数据实际:71
12:09:14 SQL> select dbms_lob.substr(bbb,dbms_lob.instr(bbb,'f')-1) from tlob;DBMS_LOB.SUBSTR(BBB,DBMS_LOB.INSTR(BBB,'F')-1)
-------------------------------------------------------------------------------
asd
tst
实际:100
12:09:36 SQL>
不知有没有更好的方式
12:09:03 SQL> select * from tlob; AAA BBB
--------- ---------------------------------------------------------------------
1 asdfasdf
1 tstfifof;fff]v]
1 数据实际:71
12:09:14 SQL> select dbms_lob.substr(bbb,dbms_lob.instr(bbb,'f')-1) from tlob;DBMS_LOB.SUBSTR(BBB,DBMS_LOB.INSTR(BBB,'F')-1)
-------------------------------------------------------------------------------
asd
tst
实际:100
12:09:36 SQL>
SQL> set serveroutput on
SQL> declare
2 v_clob clob:='1111';
3 begin
4 dbms_lob.write(v_clob,2,2,'22');
5 dbms_output.put_line(v_clob);
6 end;
7 /
1221
而且我肯定是通过cursor来循环每一条数据,cursor是可写的吗,能对它进行修改,直接返回数据库?