Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to insert newline in a column value

$a!Jan 7 2019 — edited Jan 8 2019

Hi All,

I need to insert a column with a varchar2 value, that has multiple lines.

How can I do that?

Insert into abc(c1) values

(

'I want to insert a paragraph

in multiple lines');

O/p:

I want to insert a paragraph

in multiple lines.

Please suggest.

Comments
Post Details
Added on Jan 7 2019
12 comments
10,806 views