Home » SQL & PL/SQL » SQL & PL/SQL » inserting value into varchar2 data type that contains new line
inserting value into varchar2 data type that contains new line [message #2809] Wed, 14 August 2002 07:23 Go to next message
Martina
Messages: 3
Registered: August 2002
Junior Member
Hello,

I have a problem when I want to insert into the field -varchar2(50) data type - a value that looks like this:

'aaaa

bbb bbbb'

I get this error message:
SP2-0734: unknown command beginning "bbb..." - rest of line ignored.

The problem is because of the new line between aaaa and bbb rows.
Do you have any ideas how to insert such a string into the given field of the table?

Thank you
Martina.

Report message to a moderator

Re: inserting value into varchar2 data type that contains new line [message #2823 is a reply to message #2809] Thu, 15 August 2002 06:11 Go to previous message
Abul Fazal
Messages: 39
Registered: February 2002
Member
The condition looks funny. Can u elaborate a little bit more for the need to have a blank line instead of blank spaces.

Report message to a moderator

Previous Topic: inserting a value of varchar2 containig new line
Next Topic: Complex sequence
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 08:18:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.