Home » RDBMS Server » Server Utilities » Loading data with double quotes and quotes
Loading data with double quotes and quotes [message #72232] Fri, 18 April 2003 16:51 Go to next message
Sudha
Messages: 29
Registered: November 2000
Junior Member
Help!
I am loading data into oracle with sql loader. My table has a memo field with double quotes and quotes. How can I tell the loader to escape them?
Sudha

Report message to a moderator

Re: Loading data with double quotes and quotes [message #72235 is a reply to message #72232] Mon, 21 April 2003 04:30 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

> a memo field with double quotes and quotes

Use clause:

fields terminated by "," optionally enclosed by '"'

Best regards.

Frank

Report message to a moderator

Previous Topic: Insert scripts in a flat file to be excuted
Next Topic: run sqlldr in forms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 08 20:22:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.