to beckhambobo: oracle可以这样insert SQL> select * from d;PERSON_ID SUPERVISOR ---------- ---------- aa bb bb cc cc dd ee ffSQL> insert into d select * from d where rownum<2;已创建 1 行。SQL> select * from d;PERSON_ID SUPERVISOR ---------- ---------- aa bb bb cc cc dd ee ff aa bb
很谢谢你 但我想用 INSERT 语句 因为我是在 ASP中调用 所以不能每次执行时建新表
这个可能是由于字段数目不对,这样
INSERT INTO A(colname1,colname2) SELECT B.a,B.b FROM B,C WHERE 条件
我是用的你那种办法
INSERT INTO A(colname1,colname2) SELECT B.a,B.b FROM B,C WHERE 条件
并且字段数目是一样的 我都看了好多遍了 但是插入时还是提示ORA-00917: missing comma
我都整了好久了 还是找不到那里错误 逗号我也看了好多遍了 也没少啊
sSQL="INSERT INTO tmpIV002_I (" sSQL=sSQL & "SOURCE, "
sSQL=sSQL & "CCN, "
sSQL=sSQL & "MAS_LOC, "
sSQL=sSQL & "ITEM, "
sSQL=sSQL & "REVISION, "
sSQL=sSQL & "ITRN_HIS_DATE, "
sSQL=sSQL & "ITRN_HIS_TERMINAL, "
sSQL=sSQL & "ITRN_HIS_TIME, "
sSQL=sSQL & "ITRN_HIS_SEQ, "
sSQL=sSQL & "REF, "
sSQL=sSQL & "REF_LINE, "
sSQL=sSQL & "CONSUMABLE, "
sSQL=sSQL & "AGC, "
sSQL=sSQL & "GL_ACCT, "
sSQL=sSQL & "LOCATION, "
sSQL=sSQL & "BIN, "
sSQL=sSQL & "PUR_CCN, "
sSQL=sSQL & "RECEIVER, "
sSQL=sSQL & "REC_LINE, "
sSQL=sSQL & "VENDOR, "
sSQL=sSQL & "PUR_LOC, "
sSQL=sSQL & "BUY_SELL_COST, "
sSQL=sSQL & "QTY, "
sSQL=sSQL & "USR_, "
sSQL=sSQL & "POSTING_DATE, "
sSQL=sSQL & "TRAN_COST, "
sSQL=sSQL & "INSP_STAT, "
sSQL=sSQL & "MRB_DISP, "
sSQL=sSQL & "FROM_TO_CCN, "
sSQL=sSQL & "FROM_TO_MAS_LOC, "
sSQL=sSQL & "REASON, "
sSQL=sSQL & "PROCESS_ID, "
sSQL=sSQL & "Quantity "
sSQL=sSQL & ") " sSQL=sSQL & "SELECT ITRN_HIS.SOURCE || '-' || ITRN_HIS.SOURCE_QUAL, "
sSQL=sSQL & "ITRN_HIS.CCN, "
sSQL=sSQL & "ITRN_HIS.MAS_LOC, "
sSQL=sSQL & "ITRN_HIS.ITEM AS, "
sSQL=sSQL & "ITRN_HIS.REVISION, "
sSQL=sSQL & "ITRN_HIS.ITRN_HIS_DATE, "
sSQL=sSQL & "ITRN_HIS.ITRN_HIS_TERMINAL, "
sSQL=sSQL & "to_char(to_date(ITRN_HIS.ITRN_HIS_TIME,'hh24:mi:ss'),'hh24:mi:ss'), "
sSQL=sSQL & "ITRN_HIS.ITRN_HIS_SEQ, "
sSQL=sSQL & "LTrim(ITRN_HIS.REF), "
sSQL=sSQL & "LTrim(ITRN_HIS.REF_LINE), "
sSQL=sSQL & "ITRN_HIS.CONSUMABLE, "
sSQL=sSQL & "ITRN_HIS.AGC AS, "
sSQL=sSQL & "ITRN_HIS.GL_ACCT, "
sSQL=sSQL & "ITRN_HIS.LOCATION, "
sSQL=sSQL & "ITRN_HIS.BIN AS, "
sSQL=sSQL & "ITRN_HIS.PUR_CCN, "
sSQL=sSQL & "ITRN_HIS.RECEIVER, "
sSQL=sSQL & "ITRN_HIS.REC_LINE, "
sSQL=sSQL & "ITRN_HIS.VENDOR, "
sSQL=sSQL & "ITRN_HIS.PUR_LOC, "
sSQL=sSQL & "ITRN_HIS.BUY_SELL_COST, "
sSQL=sSQL & "ITRN_HIS.QTY, "
sSQL=sSQL & "ITRN_HIS.USR_, "
sSQL=sSQL & "ITRN_HIS.POSTING_DATE, "
sSQL=sSQL & "ITRN_HIS.TRAN_COST, "
sSQL=sSQL & "ITRN_HIS.INSP_STAT, "
sSQL=sSQL & "ITRN_HIS.MRB_DISP, "
sSQL=sSQL & "ITRN_HIS.FROM_TO_CCN, "
sSQL=sSQL & "ITRN_HIS.FROM_TO_MAS_LOC, "
sSQL=sSQL & "ITRN_HIS.REASON, "
sSQL=sSQL & "ITRN_HIS.PROCESS_ID, "
sSQL=sSQL & "(ITRN_HIS.QTY)*(LIST.MULTIPLIER) "
'sSQL=sSQL & "INTO tmpIV002_I "
sSQL=sSQL & "FROM "
sSQL=sSQL & "ITRN_HIS, "
sSQL=sSQL & "LIST "
sSQL=sSQL & "WHERE ITRN_HIS.ITEM='" & Item_code & "' "
'sSQL=sSQL & "INTO tmpIV002_I "
是不是除了这句外 应该没什么错误了把?
很谢谢你能看长长的代码.
sSQL=sSQL & "WHERE ITRN_HIS.ITEM='" & Item_code & "' ;"
我在 SQL/PLUS中 就是 ORA-00917: missing comma
这个错误
set cm1 = Server.CreateObject("ADODB.Command")
cm1.ActiveConnection = MM_conn_STRING
cm1.CommandText = strsql
cm1.CommandType = 1
cm1.CommandTimeout = 0
cm1.Prepared = true
cm1.Execute()
...........
oracle可以这样insert
SQL> select * from d;PERSON_ID SUPERVISOR
---------- ----------
aa bb
bb cc
cc dd
ee ffSQL> insert into d select * from d where rownum<2;已创建 1 行。SQL> select * from d;PERSON_ID SUPERVISOR
---------- ----------
aa bb
bb cc
cc dd
ee ff
aa bb
可就是这个不行 出鬼了 我都整疯了 他还是说ORA-00917: missing comma