OraFAQ Forum: Server Administration » loading hard returns in text fields

Home » RDBMS Server » Server Administration » loading hard returns in text fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

loading hard returns in text fields [message #373390]

Fri, 13 April 2001 11:26

Paula
Messages: 4
Registered: April 2001

Junior Member

I have a text field in my database and am loading data from a csv file. The text field has several lines of data and I would like to separate them by hard returns. I thought that using the | character would do this but it's insterting this character in the field. I swore I had done this before but it just isn't working. Any help would be appreciated.

Report message to a moderator

Re: loading hard returns in text fields [message #373392 is a reply to message #373390]

Fri, 13 April 2001 12:14

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

chr(10) is a new line character.

select 'hello'||chr(10)||'world' from dual;

insert into tab values(line1||char(10)||line2);

insert into tab values
('first line
second line');

Report message to a moderator

Previous Topic:	DELETE MULTIPLE TABLES FROM QUERY RESULT
Next Topic:	decode command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 01:05:18 CDT 2024