Q: Update a string that spans multiple lines

From: Andy Tran <atran_at_sark.com>
Date: Wed, 2 Jun 1999 09:32:20 -0400
Message-ID: <7j3bu4$noi$1@athena.netset.com>

Hi all,

I'm trying to use this update statement

SQL> update my_table

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

to try to get this string

---

This is the first line

This is the second line

---

I need to have a blank line between the two lines above, but sqlplus kicks me out to the SQL> prompt after line 4. My question is: how do I get the blank line into the string? (my_column is set to varchar2(2000))

Thanks in advance Received on Wed Jun 02 1999 - 08:32:20 CDT