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 is used in Oracle and many other SQL dialects to extract a specific substring from a string. INSTR finds the position of a substring, while SUBSTRING is the standard name in SQL Server/MySQL but not Oracle.

Keep practicing — related questions