how to insert new line in insert query in oracle 11g sql

Question

i want to insert new line between these two line in db."Asperger's syndrome have difficulty with social interaction and communication.They also have a narrow range of interests." i want my o/p to be like this

'Asperger's syndrome have difficulty with social interaction and communication.
They also have a narrow range of interests.'

insert into ab(column) values ('a'+char(10)+'b');

i tried to insert like this but sql shows error

Error report -

SQL Error: ORA-00936: missing expression 00936. 00000 - "missing expression"
*Cause:

dnoeth · Accepted Answer · 2016-04-28 17:41:53Z

5

The operator for string concatenation in Oracle is || and the function name is CHR instead of CHAR.

insert into ab(column) values ('a' || chr(10) || 'b');

answered Apr 28, 2016 at 17:41

dnoeth

60.5k4 gold badges45 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

robhit · Accepted Answer · 2016-04-29 05:53:20Z

-1

    insert into ab
  (col1)
values
  (q'[Asperger's syndrome have difficulty with social interaction and communication.]' ||
   chr(13) || 'They also have a narrow range of interests.')

Use the above code for your requirement.

answered Apr 29, 2016 at 5:53

robhit

91 bronze badge

Collectives™ on Stack Overflow

how to insert new line in insert query in oracle 11g sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related