Multiple choice technology testing

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

SUBSTR is the Oracle SQL function that extracts a portion of a character string. It takes the string, starting position, and optionally length as parameters. INSTR finds position, not substring, and SUBSTRING is not standard Oracle syntax (though some databases support it).