PL/SQL (MOSC)

MOSC Banner

Sqlloader lssues

edited May 29, 2014 12:00PM in PL/SQL (MOSC) 5 commentsAnswered

Hi,

I have loaded a csv using sqlloader.  But some of the apostrophe' is not coming up properly.  It is seen as a '?'.

Here is a part of my ctl file script;

OPTIONS (SKIP = 1)

load data

CHARACTERSET WE8MSWIN1252

infile '/tmp/occi/occi.csv'

insert into table GRAYS_WEBSITE_OCCI_TEMP

fields terminated by ","

optionally enclosed by '"'

trailing nullcols

(

  LANGUAGE char(8),

  ORACLE_ITEM_CODE char(40)    ,

  OCCITANE_CODE   char(15)     ,

  PRODUCT_NAME         char(1500),

  PRODUCT_DESC         char(1500) ,

  STATUS               char(25),

  SKIN_TYPE            char(100))

Here is a sample of my data.  Note that I have given for field product_desc

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center