db2为何不能trim变量?
为何DB2不支持TRIM变量?如以下语句在DB2执行时会报错SELECT COL_1 FROM TABLE WHERE COL_1 = trim(@val),而SELECT trim(COL_1) FROM TABLE WHERE COL_1 = 'abc'则没问题,ORACLE执行相同语句也没问题。WHY?是基于什么考虑?
某xx的点心
10 years, 6 months ago