$ sqlplus myuser/mypass
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Jun 30 10:22:42 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning option
JServer Release 9.2.0.2.0 - Production
SQL> desc tom
Name Null? Type
----------------------------------------- -------- ----------------------------
MYDATE DATE
SQL> select * from tom;
no rows selected
SQL>
$ type x.dat
20050505
20060101
$ type x.ctl
load data
infile 'x.dat'
append
into table tom
fields terminated by ',' optionally enclosed by '"'
(mydate date "yyyymmdd"
"decode(substrmydate,1,4),'2006','2005'||substrmydate,5,4),:mydate)")
$ sqlloader myuser/mypass control=x.ctl
SQL*Loader: Release 9.2.0.2.0 - Production on Fri Jun 30 10:25:41 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - logical record count 2
$
$ sqlplus capel/james
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Jun 30 10:26:27 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning option
JServer Release 9.2.0.2.0 - Production
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.