create table a as select b.a,b.b from b,c where ...;
解决方案 »
- ORA0-00902 无效数据类型
- enterprise manager只能运行几分钟
- Oracle ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小
- oracle 扩展索引 ODCIIndexStart 参数问题
- 【挑战】关于oracle 查询问题,看起来很简单,但就是很难!
- 如何从数据库中取一条数据,用oracle 语句?
- 有没有什么好的role关系表设计 提供一个呀
- 我的OS是日文版本,装的Plsql developer,显示出来的数据是乱码,高分请教解决方案!
- oracle 启动问题,表示感谢!
- 急贴,oracle9i在linux下的安装问题!!!!
- 在oracle9i中,连接被拒绝?
- ORACLE817安装问题
很谢谢你 但我想用 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