Answer the question
In order to leave comments, you need to log in
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"
)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question