update a set money_status=1,money_date=sysdate where owerid=4为什么在程序里老报错?
错误:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14' [Microsoft][ODBC driver for Oracle]语法错误或违反访问规则
错误:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14' [Microsoft][ODBC driver for Oracle]语法错误或违反访问规则
select money_status,money_date from a where owerid=4;
set money_status = 1,
money_date = to_date(to_char(sysdate, 'yyyy-mm-dd hh24miss'),'yyyy-mm-ddhh24miss')
where owerid = 4
这种写法是没有问题的楼上的意思是让你show一下表结构,顺便show一下你表里面的数据