Concept and usage of Plsql_sql loader (concept)

2014-06-08 Baoxinjian

First, summary

1. Basic syntax

2. Description of operating data

Second, the specific analysis

1. Basic Syntax

1Options (Skip=1, rows= -)--1. Control file Parameters2 3     LoadData--2. Control file Identification4 5InFile'Test.txt' 　　　　　　  --3. The data file to be entered is named Test.txt6 7Append into Tabletable_name--4. Append records to the table test8 9Fields terminated by ',' 　    --5, the field terminates at X ' 09 ', is a tab (tab)Ten  OneOptionally enclosed by '"'   --6, each field with "" box, in case there is a comma in the field A  -Trailing Nullcols--7, the table field does not have a corresponding value is allowed to be empty -  the (Invoice_num "trim (: Invoice_num)", -  - last_updated_date Sysdate, -  +Last_updated_by experssion "Sys_context ('USERENV','Session_userid')", -  + creation_date Sysdate, A  atCreated_by experssion "Sys_context ('USERENV','Session_userid')")

2. Description of operating data

(1). Insert: The default way, the table that requires action has no value

(2). Append: Adding new records to the table

(3). Replace: Delete old records <delete from tablename>

(4). Truncate: Delete old records <truncate table table name>