--STEP: 1—Create Table
DROP TABLE min_max_staging
CREATE TABLE
min_max_staging
(segment1 VARCHAR2(250),
segment2 VARCHAR2(250),
segment3 VARCHAR2(25),
segment4 VARCHAR2(250),
planner_code VARCHAR2(15),
attribute16 VARCHAR2(250),
min_minmax_quantity number, --VARCHAR2(250),
max_minmax_quantity number --VARCHAR2(250),
)
--STEP: 2—Create Control file
OPTIONS(SKIP=1)
LOAD DATA
INFILE 'e:\FLAT_FILE.txt' -----give local path address
here
INSERT---APPEND --TRUNCATE --REPLACE
INTO TABLE MIN_MAX_STAGING
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(SEGMENT1 "TRIM(:SEGMENT1)",
SEGMENT2 "TRIM(:SEGMENT2)",
SEGMENT3 "TRIM(:SEGMENT3)",
SEGMENT4 "TRIM(:SEGMENT4)",
PLANNER_CODE "TRIM(:PLANNER_CODE)",
ATTRIBUTE16 "TRIM(:ATTRIBUTE16)",
MIN_MINMAX_QUANTITY "TRIM(:MIN_MINMAX_QUANTITY)",
MAX_MINMAX_QUANTITY "TRIM(:MAX_MINMAX_QUANTITY)"
)
--STEP:3—Create Flat file
--STEP:4—Move
both control file and Flat_File into E:\
--Step: 5--Import Data from Toad as below process
