Sql Loader Snippets
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sql Loader Snippets as PDF for free.
More details
- Words: 74
- Pages: 1
DATA FILE .CSV 1234, 2234, 3234, 3234, 3234, 3234, 3234, 3234,
"Imran "Imran "Imran "Imran "Imran "Imran , 323, , , ,
Baig1", Baig2", Baig3", Baig3", Baig3", Baig3", 32, 30
123, 12, 10 223, 22, 20 323, 32, 30 323, 32, 323, , 30 , 32, 30
--CONTROL FILE LOAD DATA INFILE 'D:\Materials\Oracle\Preparation\Sql-Loader\trailing_nullcols_data.csv' APPEND INTO TABLE emp1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( empno, ename, sal, comm, deptno )
"Imran "Imran "Imran "Imran "Imran "Imran , 323, , , ,
Baig1", Baig2", Baig3", Baig3", Baig3", Baig3", 32, 30
123, 12, 10 223, 22, 20 323, 32, 30 323, 32, 323, , 30 , 32, 30
--CONTROL FILE LOAD DATA INFILE 'D:\Materials\Oracle\Preparation\Sql-Loader\trailing_nullcols_data.csv' APPEND INTO TABLE emp1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( empno, ename, sal, comm, deptno )
Related Documents
Sql Loader Snippets
June 2020 7
Sql - Loader
June 2020 11
Sql Loader
November 2019 15
Sql*loader Faq
June 2020 6
Data Loading Using Sql Loader
May 2020 12