Home » SQL & PL/SQL » SQL & PL/SQL » How to append data to existing CLOB field in a oracle table (Oracle 10g)
How to append data to existing CLOB field in a oracle table [message #475243] Mon, 13 September 2010 22:53 Go to next message
francismarinus
Messages: 3
Registered: September 2010
Location: United States
Junior Member
Can anybody share the code to append data of 32k to exisitng CLOB field in an oracle table....

Report message to a moderator

Re: How to append data to existing CLOB field in a oracle table [message #475259 is a reply to message #475243] Tue, 14 September 2010 01:20 Go to previous message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just use ||.

SQL> create table t (col clob);

Table created.

SQL> insert into t values (lpad('a',32*1024));

1 row created.

SQL> update t set col = col || lpad('b',32*1024);

1 row updated.


Regards
Michel

Report message to a moderator

Previous Topic: please help in query
Next Topic: Sending Mail thru UTL_SMTP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 24 20:58:04 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.