Oracle 直接加载时控制文件中的SQL函数

SQL> create table t (
  2    c1 varchar2(10)
  3  );

Table T created.

SQL>
SQL> ho type sqlldr.ctl
load data infile *
append into table t
fields terminated by ','
trailing nullcols
(c1 "upper(:c1)" )
begindata
col1
col2

SQL>
SQL> ho sqlldr userid=chris/chris@db control=sqlldr.ctl direct=y

SQL*Loader: Release 12.2.0.1.0 - Production on Mon Jun 18 11:30:04 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Path used:      Direct

Load completed - logical record count 2.

Table T:
  2 Rows successfully loaded.

Check the log file:
  sqlldr.log
for more information about the load.

SQL>
SQL> select * from t;
C1
COL1
COL2
复制