Multiple choice technology databases

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

  1. instr

  2. substr

  3. substring

  4. pos
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The substr function in Oracle SQL extracts and returns a specific substring from a character string based on a starting position and optional length. substring is standard SQL but not native to Oracle SQL*Plus, and instr locates character positions.

Keep practicing — related questions