Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Расширенные возможности SQL
- --Команды SQL в рамках урока #16
- chcp 1251
- sqlldr
- test_user/education2020@ORCLPDB;
- CREATE TABLE KMV_EMPLOYEES_LOAD
- (
- EMPLOYEE_ID NUMBER(6),
- FIRST_NAME VARCHAR2(20),
- LAST_NAME VARCHAR2(25),
- HIRE_DATE DATE,
- JOB_ID VARCHAR2(10),
- SALARY NUMBER(8,2),
- MANAGER_ID NUMBER(6),
- DEPARTMENT_ID NUMBER(4)
- );
- SELECT * FROM KMV_EMPLOYEES_LOAD;
- --содержимое файла my_loader.ctl
- OPTIONS (SKIP=1)
- LOAD DATA
- CHARACTERSET UTF8
- INFILE 'employees.csv'
- BADFILE 'my_loader.bad'
- DISCARDFILE 'my_loader.dsc'
- TRUNCATE
- INTO TABLE KMV_EMPLOYEES_LOAD
- FIELDS TERMINATED BY ';'
- OPTIONALLY ENCLOSED BY '"'
- TRAILING NULLCOLS
- (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, HIRE_DATE, JOB_ID, SALARY, MANAGER_ID, DEPARTMENT_ID)
- sqlldr userid=test_user/education2020@ORCLPDB control=my_loader.ctl
- --содержимое файла start_load.cmd
- @echo off
- chcp 1251
- sqlldr userid=test_user/education2020@ORCLPDB control=my_loader.ctl
- pause
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement