SQL 面试题与答案
Question: Difference between SUBSTR and INSTR?Answer: INSTR (String1, String2 (n, (m)),INSTR returns the position of the m-th occurrence of the string 2 in string1. The search begins from nth position of string1. SUBSTR (String1 n, m) SUBSTR returns a character string of size m in string1, starting from n-th position of string1. |
保存以便复习
收藏此条目、标记为困难题，或将其加入复习集合。
这有帮助吗？ 是 否
用户评价最有帮助的内容：