controlfile Questions
2
Below is my Control file example :
OPTIONS (skip=1,errors=1000,direct=true,rows=10000)
load data
append
into table TABLE_NAME
fields terminated by ','
OPTIONALLY ENCLOSED BY '"'
trailing ...
Bullhead asked 22/1, 2014 at 9:19
2
Solved
I'm trying to load data from a file and I want to set CREATED_DATE and UPDATED_DATE to SYSDATE and CREATE_BY and UPDATED_BY to USER
Here the table that I'm working with:
CREATE TABLE CATALOG
(CNO...
Sorel asked 14/8, 2010 at 20:21
1
© 2022 - 2024 — McMap. All rights reserved.