string sql = "insert into EMST_JC_SBXX(XL,SBBM,SBWH,SBMC,CCBM,XNCS,CZXL,ZL,GL,ZZCJ,TCRQ,SYQX,XHGG,ZT,SFTZSB,CGJ,TH,BZ) values(EMST_JC_SBXX_XL.nextval,'" + SBBM + "','" + SBWH + "','" + SBMC + "','" + CCBM + "','" + XNCS + "'," + Convert.ToInt32(CZXL) + "," + Convert.ToInt32(ZL) + "," + Convert.ToInt32(GL) + "," + Convert.ToInt32(ZZCJ) + ",to_date('" + Convert.ToDateTime(TCRQ).ToString("yyyy-MM-dd") + "','YYYY-MM-DD')," + Convert.ToInt32(SYQX) + ",'" + XHGG + "'," + Convert.ToInt32(ZT)
相关文章
- Oracle汇总笔记
- 用SQL server导出到oracle,查询时提示“表或视图不存在ORA-00942”错误
- [oracle]逗号(或分号等)间隔的列,按这一列劈分后转多行
- Java for LintCode 链表插入排序
- Oracle Database 12.2新特性详解
- Display LOV (List Of Values) Using Show_Lov In Oracle Forms
- Oracle ORA-01033: ORACLE initialization or shutdown in progress 错误解决办法Windows版(手贱强制重启电脑的后果)
- ORACLE initialization or shutdown in progress 错误解决办法
- Oracle ORA-01033: ORACLE initialization or shutdown in progress 错误解决办法. 重启服务
- 解决Oracle ORA-01033: ORACLE initialization or shutdown in progress错误 和 ORA-01589错误 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项