Oracle SQLLDR Use (fast import, but weak handling of the data itself)

Oracle SQLLDR Use (fast import, but weak handling of the data itself) Blog Category:

• Db. Oracle

Oraclesql Sqlload.cmd
SQL code

1. Pause
2. Sqlldr user/[email protected] control.ctl skip=1 rows=2000 bindsize=8192000
3. Pause

Control.ctl
SQL code

2. LOAD DATA
4. INFILE ' rating201001.csv '
6. APPEND
8. into TABLE "Tbl_sell"
10. Fields TERMINATED by ', ' optionally enclosed by ' "'
12. --fields TERMINATED by ', '
14. --NULL is allowed when the table field does not have a corresponding value
16. TRAILING Nullcols
18. --The following field order corresponds to the comma-separated field order in the CSV file, and you can refer to the values of other columns by using: Field names
20. (
22. Src_type_code,
24. --Year_month "201002", ignoring the second column value and using a fixed value
26. Year_month,
28. P_index,
30. Province,
32. City,
34. Country,
36. Shop_name "trim (: Shop_name)",
38. Shop_code,
40. Brand_Name,
42. Sell_count,
44. Sell_money,
46. Shop_rating,
48. Type_code "decode (: Src_type_code,10,5,:src_type_code)"
50. )

Oracle SQLLDR is used (import is fast, but processing of the data itself is weak)