2012年9月6日
oracle 更新多条数据
摘要： UPDATE WW_TRANSITDETAIL t SET t.WW6_PLANDELIVERNUMBER = (CASE WHEN WW6_ID ='2136' THEN 1 WHEN WW6_ID ='2137' THEN 1 WHEN WW6_ID ='2138' THEN 1 WHEN WW6_ID ='2139' THEN 1 WHEN WW6_ID ='2140' THEN 1 WHEN WW6_ID ='2141' THEN 1 ELSE WW6_PLANDELIVERNUMBER E 阅读全文
posted @ 2012-09-06 16:05 云海之上 阅读(4136) 评论(0) 推荐(0) 编辑
ORA-00932: inconsistent datatypes: expected A got B
摘要： 数据类型不一致: 应为 A, 但却获得Binconsistent datatypes: expected CHAR got NUMBER赋值时未加“”号 阅读全文
posted @ 2012-09-06 16:02 云海之上 阅读(512) 评论(0) 推荐(0) 编辑