Hard return in the insert statement

How can I insert the data that contain the line breaks or hard return ?

via what mechanism?

Quote:

---

Originally posted by Blu
How can I insert the data that contain the line breaks or hard return ?

---

You can concatenate a CHR(10).

Code:

---

INSERT INTO blah ('blah blah blah blah blah blah ' || CHR(10) ||
                  'blah blah blah blah blah blah ' );

---

Thanks.