Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2015
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. DECLARE
  2. str varchar2(32767);
  3. BEGIN
  4. str := 'Very-very-...-very-very-very-very-very-very long string value';
  5. update t1 set col1 = str;
  6. END;
  7. /
  8.  
  9. Insert into table (clob_column) values ( to_clob( 'chunk 1' ) || to_clob( 'chunk 2' ) );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement