SCOTT@orcl12c_11gR2> host type test.dat
ACCOUNTING|NEW YORK
RESEARCH|DALLAS
SALES|CHICAGO
OPERATIONS|BOSTON

SCOTT@orcl12c_11gR2> host type test.ctl
load data
into table dept2
fields terminated by '|'
trailing nullcols
(dname, loc, deptno sequence)

SCOTT@orcl12c_11gR2> create table dept2 as select * from dept where 1 = 2
  2  /

Table created.

SCOTT@orcl12c_11gR2> select * from dept2
  2  /

no rows selected

SCOTT@orcl12c_11gR2> host sqlldr scott/tiger control=test.ctl log=test.log direct=true

SQL*Loader: Release 12.1.0.1.0 - Production on Thu Aug 15 12:30:28 2013

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

Path used:      Direct

Load completed - logical record count 4.

Table DEPT2:
  4 Rows successfully loaded.

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

SCOTT@orcl12c_11gR2> select * from dept2
  2  /

    DEPTNO DNAME          LOC
---------- -------------- -------------
         1 ACCOUNTING     NEW YORK
         2 RESEARCH       DALLAS
         3 SALES          CHICAGO
         4 OPERATIONS     BOSTON

4 rows selected.