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?是基于什么考虑?

db2

某xx的点心 10 years, 6 months ago

Your Answer