Re: Q: Update a string that spans multiple lines

From: Dmitry M.Seminikhin <sam_at_eximb.kiev.ua>
Date: Thu, 3 Jun 1999 11:19:58 +0300
Message-ID: <ACkgZLt0XN@eximb.kiev.ua>

If you need a line feed you should write smth like update my table set my_column=
'This is the first line'||chr(10)||
'This is the second line'

;
Hope it will help
AT> Hi all,

AT> I'm trying to use this update statement

SQL>> update my_table

AT>     2   set my_column =
AT>     3  'This is the first line
AT>     4
AT>     5   This is the second line'
AT>     6  ;

AT> to try to get this string

AT> ---------------------------------------------------------------------------

AT> This is the first line

AT> This is the second line

AT> ---------------------------------------------------------------------------

AT> I need to have a blank line between the two lines above, but sqlplus kicks
AT> me out to the SQL> prompt after line 4.

AT> My question is: how do I get the blank line into the string? (my_column is AT> set to varchar2(2000))

AT> Thanks in advance Received on Thu Jun 03 1999 - 03:19:58 CDT