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中需要执行显式的类型转换。
You can also use it declaratively to simplify casting to a text string.
还可以通过声明方式使用该方法以简化到文本字符串的转换。
You can also use it declaratively to simplify casting to a text string.
还可以通过声明方式使用该方法以简化到文本字符串的转换。
应用推荐