Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use sqlldr, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Sqlldr userid=btupayprod/Tyzf2012 control=/home/bestpay/gt/demo.ctl direct=true parallel=true data=/home/bestpay/gt/425_26.csv

1. Create a new table under the user who wants to import data:

Create table TMP_CZY_0420_2

(

Cust_name VARCHAR2 (200)

Id_card_no VARCHAR2 (20)

Mobile_no VARCHAR2 (20)

Bussiness_type VARCHAR2 (20)

Pre_cert_amount VARCHAR2 (20)

Cert_date VARCHAR2 (30)

Expiration_date VARCHAR2 (30)

Status VARCHAR2 (10)

);

2. Create a script file in the format that ends with ctl.

Load data

Infile'D:\ quick_noquick\ quick_noquick.csv'

Into table tmp_czy_0420_3

Append

FIELDS TERMINATED BY', 'OPTIONALLY ENCLOSED BY' "'

(cust_name

Id_card_no

Mobile_no

Bussiness_type

Pre_cert_amount

Cert_date

Expiration_date

Status

)

3. Use sqlldr's import statement:

Sqlldr userid=crpay/Rfs2F1\ (p control=/home/pcloud/test.ctl direct=true parallel=true data=/home/pcloud/VIP_ whitelist _ 0506.csv

Sqlldr userid=crpay/Rfs2F1\ (p control=/home/pcloud/test.ctl direct=true parallel=true data=/home/pcloud/VIP_ whitelist _ 0506.csv

The above is all the contents of this article "how to use sqlldr". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.