insert into USERINFO (ID,USERNAME,PWDHASH,USEALIAS,ALIAS,REALNAME,INUSE,F_BRANCH_ID,MOBILEPHONE,TELEPHONE,EMAIL,LICENSECODE,
ADDRESS,POSTCODE,GENDER,F_CUSTOMER_ID,Iscore,ACTIVETIME,EXPIRETIME,IP)
values (248,'police','94216d6c554585824505a697b354b2b1',null,'','realname',1,223,'mobile','phone','1@163.com','address','M',163,to_date('11-04-2013',
'dd-mm-yyyy'),to_date('19-04-2013','dd-mm-yyyy'),'192.168.0.0');
想要将类似to_date('19-04-2013','dd-mm-yyyy')的内容替换为null。
替换后的结果如下:
insert into USERINFO (ID,null,
'192.168.0.0');