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

SUBSTR returns a specified portion of a character string given a start position and optional length. INSTR finds position of a substring, SUBSTRING is not an Oracle function (it's ANSI SQL), and POS is not a standard Oracle character function.

Keep practicing — related questions