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

In Oracle SQL, SUBSTR is the standard function used to extract a substring. INSTR searches for a substring and returns its position, and POS is not a valid Oracle character function. Although SUBSTRING is standard in other SQL dialects, SUBSTR is correct in Oracle.

Keep practicing — related questions