Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- str varchar2(32767);
- BEGIN
- str := 'Very-very-...-very-very-very-very-very-very long string value';
- update t1 set col1 = str;
- END;
- /
- Insert into table (clob_column) values ( to_clob( 'chunk 1' ) || to_clob( 'chunk 2' ) );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement