Inserting text which contains newlines, using SQL

Hi all,

Is there a reliable way to insert text which contains newlines using SQL?
I know it's easy using JDBC and a prepared statement, but I would like to figure out how to do it interactively in sql*plus, or in a SQL script.

I have found this to work somewhat:

insert into sometable values ( 'somekey', 'This is text with an embedded newline.');

If you check the table, there is now a string in there with a newline between the words "with" and "an".
This is fine so far, but this does not work if you have a blank line (two consecutive newlines, or two newlines separated only by space characters); if sql*plus sees a blank line it simply cancels the current command.

Is there a way around this? I'd appreciate any ideas!

Thanks!

• Thomas Okken

--
Thomas Okken
AT&T Labs, 200 Laurel Ave S., room A4-1A33, Middletown, NJ 07748
email: tokken_at_arrow.lz.att.com
phone: (732)-420-8063