ORACLE 字段处理记录

修改字段长度

ALTER TABLE   CT_BD_OAPersonSynEntry  ALTER COLUMN   CFPhone       nVARCHAR(44)  

 sql插入业务日期 

  Date recDate = receivingBillInfo.getBizDate();//业务日期日期
    	      SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");;
    		  String dateformat = simpleDateFormat.format(recDate); 
    	      StringBuffer insertSql = new StringBuffer();
    	      insertSql.append(" /*dialect*/ insert into   [192.168.0.253].AreaCon_XZZB.dbo.AsycKD_incorech   ( fdate, fcustno,fcust, FEmpNo,  femp, famt,fComNo , fcontractno)    ");
    	                                                          insertSql.append   ( "  values  ( '"+dateformat+"', '"+payerNumber+"'  , '"+payerName+"'    , '"+personNumber+"'  , '"+personName+"'  , '"+localAmt+"'  , '"+companyNumber+"'  , '"+projectNumber+"' ) "  );
    	      boolean exeSQL = SQLFacadeFactory.getRemoteInstance().exeSQL(insertSql.toString()); 

 数据库字段 插入时间戳

FLastUpdateTime=to_timestamp(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')