Tuesday, May 8, 2018

SQL Query

How to insert System Date

INSERT

String inserSql = "Insert into PROMO_FILTER_CX_INFO (MOBILE, STATUS,REQUEST_DATE) Values (?, ?,SYSDATE)";
jdbcTemplate.update(inserSql,addCampaignBlackListCxRq.getMobileNo(),"OFF");

UPDATE

String updateSql = "UPDATE PROMO_FILTER_CX_INFO pfci SET pfci.STATUS = 'OFF',pfci.REQUEST_DATE = SYSDATE WHERE pfci.MOBILE=? ";
jdbcTemplate.update(updateSql,addCampaignBlackListCxRq.getMobileNo());

No comments:

Post a Comment