Multiple choice technology programming languages

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

  1. SUBSTR

  2. INSTR

  3. SUBSTRING

  4. POS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SUBSTR extracts a portion of a string by specifying start position and length. INSTR returns the position of a substring within a string. While SUBSTRING exists in some SQL dialects (SQL Server), SUBSTR is the standard function in Oracle, MySQL, and PostgreSQL. POS is not a standard SQL character function.

Keep practicing — related questions