make CLOB backup column

Question

i got a 3 CLOB columns , i have to manipulate them and to recreate data i tryed to make backup columns, like this:

update
tbl_order_webform
set mail_bak = mail_html

but the back up column is empty after the script.

is this even possible? or is this any other way to create a back for them?

woops, ty... even thught i read something about this isnt possible, well thats for that. Thx again. — Barta Tamás, Jan 28 '13 at 09:20
@Rene you may want to submit this as an answer so i can accept. — Barta Tamás, Jan 28 '13 at 09:23

score 0 · Answer 1 · answered Jan 28 '13 at 13:34

0

You have to commit your changes in order to see them in another session.

answered Jan 28 '13 at 13:34

Rene

1 Answers1