How can I insert the data that contain the line breaks or hard return ?
via what mechanism?
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 ' );
INSERT INTO blah ('blah blah blah blah blah blah ' || CHR(10) || 'blah blah blah blah blah blah ' );
Thanks.
Forum Rules