infile * 不能和str屬性連用
[oracle@yitai ~]$ sqlplus scott/oracle
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 30 14:19:09 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc test;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID VARCHAR2(10)
AGE VARCHAR2(10)
USERNAME VARCHAR2(10)
[oracle@yitai ~]$ vi test.ctl
load data
infile * "str x'2a2a0a'"
truncate into table test
fields terminated by ','
(
id ,
age ,
username
)
1,24,Jack**
2,25,Tom**
3,26,Jane**
[oracle@yitai ~]$ sqlldr scott/oracle control=test.ctl
SQL*Loader: Release 10.2.0.4.0 - Production on Tue Oct 30 14:19:50 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-283: file processing string "str x'2a2a0a'" ignored for INFILE *
SQL*Loader-350: Syntax error at line 10.
Expecting keyword INTO or keyword BEGINDATA, found "1".
1,24,Jack**
^
根據測試結果:控制檔案test.ctl裡infile * 不能和str屬性連用。
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 30 14:19:09 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc test;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID VARCHAR2(10)
AGE VARCHAR2(10)
USERNAME VARCHAR2(10)
[oracle@yitai ~]$ vi test.ctl
load data
infile * "str x'2a2a0a'"
truncate into table test
fields terminated by ','
(
id ,
age ,
username
)
1,24,Jack**
2,25,Tom**
3,26,Jane**
[oracle@yitai ~]$ sqlldr scott/oracle control=test.ctl
SQL*Loader: Release 10.2.0.4.0 - Production on Tue Oct 30 14:19:50 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-283: file processing string "str x'2a2a0a'" ignored for INFILE *
SQL*Loader-350: Syntax error at line 10.
Expecting keyword INTO or keyword BEGINDATA, found "1".
1,24,Jack**
^
根據測試結果:控制檔案test.ctl裡infile * 不能和str屬性連用。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/27042095/viewspace-747932/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- sqlldr 裝載換行符(使用str屬性)SQL
- mongodb用mongoose查庫的物件,不能增加屬性MongoDB物件
- defer 屬性和 async 屬性
- javascript原型物件的屬性不能夠覆蓋物件自有屬性JavaScript原型物件
- HTML id屬性值不能重複HTML
- 作用域、連結屬性和儲存型別型別
- MQTT 5.0 連線屬性MQQT
- JavaScript私有屬性和靜態屬性JavaScript
- 庫和屬性
- 屬性和方法
- 連結a物件的pathname屬性物件
- 超連結a的target屬性
- 深入理解和應用display屬性(二)
- JavaScript中屬性name與方法名不能相同JavaScript
- char str[]和char *str的區別
- vue計算屬性和vue實力的屬性和方法Vue
- MySQL INTO OUTFILE和LOAD DATA INFILE用法MySql
- 屬性和監聽
- a標籤的使用,以及一些全域性屬性和連結型別。型別
- border-sizing屬性詳解和應用
- HTML5中ol和li屬性應用HTML
- jsp頁面不能識別bean的屬性JSBean
- JavaScript公有屬性、私有屬性、公有方法和原型方法JavaScript原型
- JavaScript修改連結a的href屬性值JavaScript
- 將href屬性值寫入連結<a>
- C#屬性和lamdaC#
- SVG repeatCount和repeatDur屬性SVG
- Winform Anchor和Dock屬性ORM
- Function方法和屬性圖Function
- javascript layerX和layerY屬性JavaScript
- [React]屬性和狀態React
- Jmeter屬性和變數JMeter變數
- String str=null; 和String str=""的區別Null
- 第 11 章 全域性屬性和其他
- css可繼承屬性和非繼承屬性一覽CSS繼承
- C#反射設定屬性值和獲取屬性值C#反射
- SQL Server 生成C#公共實體屬性和私有屬性SQLServerC#
- javascript獲取物件直接量中的屬性和屬性值JavaScript物件