Multiple choice technology programming languages

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 is the standard SQL/Oracle function for extracting a substring. Syntax: SUBSTR(string, start_position, length). For example, SUBSTR('Hello', 1, 3) returns 'Hel'. INSTR finds position of a substring (returns a number). SUBSTRING exists in some SQL dialects but not Oracle. POS is not a standard SQL character function.

Keep practicing — related questions