create table t ( c varchar2(32767 byte) not null)
Table created.
Insert all 1's followed by a 2 at the end
insert into t(c) values (lpad('2',32767,'1'))
1 row(s) inserted.
select substr(c,32766), dump(substr(c,32766),16) from t
SUBSTR(C,32766) | DUMP(SUBSTR(C,32766),16) | 12 | Typ=1 Len=2: 31,32 |
---|
Replace the last 2 by 34
update t set c = replace(c,'2','34')
1 row(s) updated.
Two disappeared
select substr(c,32766), dump(substr(c,32766),16) from t
SUBSTR(C,32766) | DUMP(SUBSTR(C,32766),16) | 1 | Typ=1 Len=1: 31 |
---|
drop table t
Table dropped.