还可以用动态sql语句,执行load table table_name from "filename"
Function
To import data into a database table from an external ascii-format file.
Syntax
LOAD [ INTO ] TABLE [ owner ].table-name
... FROM 'filename-string'
... [ FORMAT 'ascii' ]
... [ DELIMITED BY string ]
... [ STRIP { ON | OFF } ]
... [ QUOTES { ON | OFF } ]
... [ ESCAPES { ON | OFF } ]
... [ ESCAPE CHARACTER character ]
... [ WITH CHECKPOINT { ON | OFF } ]