Can we change Case of input data in SQL LOADER ctl file?

Question

I am trying to insert data from csv to a table using sql loader. My csv has data in small Caps .But I want the data in the table to be in Large cap for some columns For some Columns it should be InitCap.

        INFILE 'abc.csv'
        INSERT INTO TABLE T_DETAILS
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
        (   
    INITCAP(f_name), 
    UPPER(f_code)```

But i am getting error like

> **SQL*Loader-350: Syntax error at line 16. Expecting "," or ")", found "(".
>     INITCAP(f_name),**
>            ^

Littlefoot · Accepted Answer · 2022-04-26 06:34:51Z

3

You can, but not like that. Should've been

load data
infile 'abc.csv' 
insert
into table t_details
fields terminated by ',' optionally enclosed by '"' trailing nullcols
(f_name     "initcap(:f_name)",
 f_code     "upper(:f_code)"
)

answered Apr 26, 2022 at 6:34

Littlefoot

144k15 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can we change Case of input data in SQL LOADER ctl file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related