-
编辑 删除
一次 sqlload问题处理
昨天晚上，测试的发现用sqlload加载数据的时候，会提示 ：被拒绝 - 表 OF_07 的列 TA_CODE 出现错误。ORA-00984: 列在此处不允许．[@more@]察看ctl文件：LOAD DATA INFILE 'C:.BCP.0' Append INTO TABLE OF_07 FIELDS TERMINATED BY X"09" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (FUNDNAME,TOTALFUNDVOL,FUNDCODE,FUNDSTATUS,NAV,CURRENCYTYPE,CUSTODIANCODE,IPOSTARTDATE,IPOENDDATE,FUNDMANAGERCODE,REGISTRARCODE,FUNDSIZE FILLER,FUNDSPONSOR,UPDATEDATE FILLER,FACEVALUE,CONVERTSTATUS FILLER,MINREDEMPTIO
-
编辑 删除
sqlplus
1.5 Comments in scriptWhen we add comments in a script file, we should very careful. Comments will lead to unexpected result in some special conditions.[@more@]1.5.1 An English letter follows closely in comment symbol '/*'In SQL*Plus, it will lead the SQL statement before the comment to be executed twice. For example, the script file “test.sql” includes follow SQL statements:select 'aaa' from dual;/*abc*/select 'bbb' from dual;We just want the statement ‘select 'aaa' from dual;’ to be execut
