sqlldr 加载数据

最新推荐文章于 2024-06-04 09:58:29 发布

happy一个世纪

最新推荐文章于 2024-06-04 09:58:29 发布

阅读量630

点赞数

分类专栏： oracle 文章标签： sqlldr

本文链接：https://blog.csdn.net/tstcylq/article/details/49743127

版权

oracle 专栏收录该内容

53 篇文章 0 订阅

订阅专栏

LOAD DATA
INFILE *
APPEND
INTO TABLE CONSIGN_ORG
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(ID,ORG_CODE,ORG_NAME,ROOT_FLAG,PARENT_CODE,SPELL_SHORT,ACTIVE_FLAG,DELETE_FLAG,REMARK,CREATE_USER,CREATE_DATETIME date 'yyyy-mm-dd hh24:mi:ss',UPDATE_USER,UPDATE_DATETIME date 'yyyy-mm-dd hh24:mi:ss')
BEGINDATA
"1","230400260000","单位1""特殊行动""名称","0","230400000000","","1","0","","admin","2015-11-06 15:14:43","",""
"2","232700010100","单位2""特殊行动""名称","0","232700010000","","1","0","","admin","2015-11-06 15:14:43","",""
"3","441302210000","单位3""特殊行动""名称","0","441302000000","","1","0","","admin","2015-11-06 15:14:43","",""
"4","441302210100","单位4""特殊行动""名称","0","441302210000","","1","0","","admin","2015-11-06 15:14:43","",""
"5","441302210200","单位5""特殊行动""名称","0","441302210000","","1","0","","admin","2015-11-06 15:14:43","",""
"6","441302210300","单位6""特殊行动""名称","0","441302210000","","1","0","","admin","2015-11-06 15:14:43","",""
"7","441302210400","单位7""特殊行动""名称","0","441302210000","","1","0","","admin","2015-11-06 15:14:43","",""
8","441302210500","单位8""特殊行动""名称","0","441302210000","","1","0","","admin","2015-11-06 15:14:43","",""

需要注意的是，如果加载的数据某列中含有包围字符，需要使得包围字符出现两次，做下转义！