strTargetTab 是定义的动态表表名
i为int型
ss[i] 是数组
代码如下
strSql = " INSERT INTO " + strTargetTab + " \n";
strSql += " ( \n";
strSql += " TIME_CD, \n";
strSql += " STD_AREA_ID, \n";
strSql += " STD_FINA_ITEM_CD, \n";
strSql += " CONVERT, \n";
strSql += " ETL_CYCLE_ID, \n";
strSql += " ETL_TIME \n";
strSql += " ) \n";
strSql += "VALUES ('" + strCycleID + "', \n";
strSql += " '" + strStdAreaID + "', \n";
strSql += " '" + i + "' ,\n";
strSql += " round(" + ss[i] + ",4), \n";
strSql += " '" + strCycleID + "' , \n";
strSql += " sysdate \n";
strSql += " ) \n";
i为int型
ss[i] 是数组
代码如下
strSql = " INSERT INTO " + strTargetTab + " \n";
strSql += " ( \n";
strSql += " TIME_CD, \n";
strSql += " STD_AREA_ID, \n";
strSql += " STD_FINA_ITEM_CD, \n";
strSql += " CONVERT, \n";
strSql += " ETL_CYCLE_ID, \n";
strSql += " ETL_TIME \n";
strSql += " ) \n";
strSql += "VALUES ('" + strCycleID + "', \n";
strSql += " '" + strStdAreaID + "', \n";
strSql += " '" + i + "' ,\n";
strSql += " round(" + ss[i] + ",4), \n";
strSql += " '" + strCycleID + "' , \n";
strSql += " sysdate \n";
strSql += " ) \n";
解决方案 »
- EXP导出数据库,有文件大小限制么
- 为什么连接池还有连接,但是系统确报取不到连接呢?
- oracle 迁移 大家能否讲点经验 谢!急!
- oracle导入导出表结构问题求助!
- 关于oracle服务的2个问题
- 急急急---ORACLE数据库查询速度变慢的原因是什么?100分
- 把表B的记录插到表A中去!
- Oracle7.34为什么不能在win2000上安装?
- 关于数据库日志问题,请oracle高手或广大系统管理员积极参与,帮我解决难题,不胜感激
- java.sql.SQLException: ORA-00600: internal error code, arguments: [kkpamRFGet0]
- 取一个月中的某一天(星期几)?焦急!各位帮帮忙,谢谢了先!
- 请教各位一个oracle 触发器的问题.
Error 168: # Illegal types associated with operator '+': 'const char *' and 'const
char *'.
strSql += " '" + i + "' ,\n";