example about control file
来源:互联网 发布:杭州朝乾网络 编辑:程序博客网 时间:2024/04/20 02:33
OPTIONS(SKIP=1)
LOAD DATA
REPLACE
INTO TABLE INV.XXINV_ITEM_ATTACH_BEK_REG
TRAILING NULLCOLS
(
PROCESS_FLAG TERMINATED BY '|' "TRIM(:PROCESS_FLAG)",
TRANSACTION_TYPE TERMINATED BY '|' "TRIM(:TRANSACTION_TYPE)",
SET_PROCESS_ID TERMINATED BY '|' "TRIM(:SET_PROCESS_ID)",
SEGMENT1 TERMINATED BY '|' "TRIM(:SEGMENT1)",
PRIMARY_UOM_CODE TERMINATED BY '|' "TRIM(:PRIMARY_UOM_CODE)",
DESCRIPTION TERMINATED BY '|' ENCLOSED BY '"' "TRIM(:DESCRIPTION)",
TEMPLATE_ID TERMINATED BY '|' "TRIM(:TEMPLATE_ID)",
ORGANIZATION_ID TERMINATED BY '|' "TRIM(:ORGANIZATION_ID)",
MASTER_ORG_ID TERMINATED BY '|' "TRIM(:MASTER_ORG_ID)" ,
REQUEST_ID DEFAULTIF REQUEST_ID=BLANKS,
RECORD_ID SEQUENCE(MAX,1)
)
- example about control file
- control file example
- an example of trajectory control about manipulators
- All about control file in Oracle Database
- Server Control Properties Example
- control file
- about version control
- About FileUpload Control - CheckFileSize
- About TreeView Control
- about AxVSFlex control
- a example about struts tag
- 13.4. A Copy-Control Example
- File Dialog Example
- Log4j Property File Example
- Example wpa_supplicant configuration file
- About DataGridView control in C#
- crazyflie control system about PID
- 25 You are using the control file to maintain information about the database backups that are being
- apache php配置
- 程序员可以增加收益的平台记录
- flex pureMVC框架的使用
- ORACLE 的权限入门
- FLASH实用代码大全
- example about control file
- 物联网时代到了——智能家居应战不容易
- Position定位:relative | absolute
- linux/unix 哲学概述 (Linux and the Unix Philosophy)
- 卢时彻:物联网是新一代信息技术应用突破的方向
- Android Audio AudioHardwareALSA::openOutputStream函数
- LINUX初学者需要了解的基础知识
- 解决OutOfMemory问题
- 遇到求职陷阱 你可以这样应对