update AREAS set OWNER_ID_V1='1',OWNER_PCT_V2='795432',OWNER_ID_V3='987',OWNER_ID_V2='654',FAX_EXT_V1='0123',OWNER_PCT_V1='1',AREA_TYPE='',OWNER_PCT_V3='658',FAX_NO_V1='456789',FAX_AC_V1='123',AREA_NAME='BJ',AREA_STATUS='1',RECORD_STATUS='1' where AREA_ID='1043970'
有值大小约束
update COMPANIES set COMPANY_NAME='marys' where COMPANY_ID='168954'
少了单引号
insert into PLANTS (PLANT_ID,STARTUP_DATE,SHUTDOWN_DATE) values ('1043890',to_date('10/09/2007'),to_date('10/29/2007','mm-dd-yyyy'))
转换日期格式(Oracle)