Here the original query is comparing a string to a number but in the modified query, explicit type-casting has been done.
原来的查询比较一个字符串和一个数字,但是在修改后的查询中执行了显式的类型转换。
For example, in Oracle, a string '1' can be compared with a numeric 1, but in DB2, explicit type-casting needs to be done.
例如,在Oracle中字符串'1 '可以与数字1比较,但是在DB 2中需要执行显式的类型转换。
For example, in Oracle, a string '1' can be compared with a numeric 1, but in DB2, explicit type-casting needs to be done.
例如,在Oracle中字符串'1 '可以与数字1比较,但是在DB 2中需要执行显式的类型转换。
应用推荐