S
S
sidor_tank2019-12-23 01:23:50
Oracle
sidor_tank, 2019-12-23 01:23:50

How to load current month records through SQL Loader?

I assume that this can be done through the WHEN section, but I did not find suitable documentation

load data
INFILE 'C:\Users\Acer\Desktop\oracle-18\info.txt'
REPLACE
INTO TABLE lab18
FIELDS TERMINATED BY ';'
(
integervalue "round(:integervalue, 2)",
charvalue "upper(:charvalue)",
datevalue date "YYYY-MM-DD"
)

Control file attached

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey c0re, 2019-12-23
@erge

try it:
see TO_DATE() - converts string to date.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question