jeudi 28 avril 2016

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

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:

Aucun commentaire:

Enregistrer un commentaire