从DB2转换为甲骨文

Question

SELECT MESSAGE_ID, SHORTDESC
FROM   VERNACULAR_MASTER
WHERE  position( chr(10), SHORTDESC, CODEUNITS16)>0
or     position( chr(13),SHORTDESC, CODEUNITS16)>0

上面的查询为DB2格式。如何将其转换为Oracle格式？

Answer 1

等效于DB2的POSITION( search_string, source_string, encoding )函数是Oracle的INSTR( string, sub_string )函数：

SELECT MESSAGE_ID, SHORTDESC
FROM   VERNACULAR_MASTER
WHERE  INSTR( SHORTDESC, CHR(10) )>0
OR     INSTR( SHORTDESC, CHR(13) )>0