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

SUBSTR is the Oracle PL/SQL function that extracts a portion of a string, taking the string, start position, and optional length parameters. INSTR returns the position of a substring (the opposite), SUBSTRING is used in SQL Server/T-SQL not Oracle, and POS is not a standard Oracle function.

Keep practicing — related questions