Home » RDBMS Server » Server Administration » loading hard returns in text fields
loading hard returns in text fields [message #373390] Fri, 13 April 2001 11:26 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:37:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.