update test set proposal_text='this is a clob text test';
create table bydcme.test ( proposal_text clob )insert into test values('this is abcdecf asdfas asdfsdaf asdf '); SQL> select * from test;
PROPOSAL_TEXT -------------------------------------------------------------------------------- this is abcdecf asdfas asdfsdaf asdfSQL> update test set proposal_text='this is a clob text test test test test clob';
1 row updated SQL> select * from test;
PROPOSAL_TEXT -------------------------------------------------------------------------------- this is a clob text test test test test clob
没有问题啊,可以更新阿, 你是要用java还是sql啊?Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 Connected as ops$global
你那个Clob里的值是从哪里来的?如果就是个字符串,直接当varchar2就行如果是个程序里的流,需要你先存一条Empty_Clob 在java里用select for update ,再对它进行修改如果是数据库服务器上的文件,直接用utl_file或者dbms_lob包内的函数,把文件写入clob对象
不好意思,建表的时候加了schema,用你登录的用户执行 create table test ( proposal_text clob ),再接着执行下面的就可以了。
(
proposal_text clob
)insert into test values('this is abcdecf asdfas asdfsdaf asdf ');
SQL> select * from test;
PROPOSAL_TEXT
--------------------------------------------------------------------------------
this is abcdecf asdfas asdfsdaf asdfSQL> update test set proposal_text='this is a clob text test test test test clob';
1 row updated
SQL> select * from test;
PROPOSAL_TEXT
--------------------------------------------------------------------------------
this is a clob text test test test test clob
Connected as ops$global
SQL> create table test(test_clob clob);
Table created
SQL> insert into test values('aaaa bbbbbbbbbb');
1 row inserted
SQL> commit;
Commit complete
SQL> select * from test;
TEST_CLOB
--------------------------------------------------------------------------------
aaaa bbbbbbbbbb
SQL> update test set test_clob = 'cccccccccccccccc333333333';
1 row updated
SQL> commit;
Commit complete
SQL> select * from test;
TEST_CLOB
--------------------------------------------------------------------------------
cccccccccccccccc333333333
SQL>
不好意思,建表的时候加了schema,用你登录的用户执行
create table test
(
proposal_text clob
),再接着执行下面的就可以了。