-
How can i load in a varchar2 column, a text that contents returns of line?
For example the sqlloader file:
James#My car is red and
my house is big.#London
Jason#Hellow my friend!#San Francisco
Patrick#What a wonderful day!#Philadelphia
And the table is:
Name varchar2(20),
Comment varchar2(250),
City varchar2(20)
Thank you.
-
You might have a control file something like this
LOAD DATA
INFILE '<filename>'
INTO TABLE <tablename>
FIELDS TERMINATED BY ’#’
OPTIONALLY ENCLOSED BY ’"’
(name, comment, city)
-
sqlloader reads line to line the text file and when it finds a return of line it rejects the record.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|