Multiple choice technology databases

Which character function can be used to return a specified portion of a character string?

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The SUBSTR function in SQL (particularly Oracle) returns a specified substring from a character input based on starting position and length. INSTR locates the position of a substring, while SUBSTRING is the syntax in other SQL dialects, and POS is not standard.

Keep practicing — related questions