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

Oracle's SUBSTR function extracts a portion of a string starting from a specified position for a specified length. INSTR returns the position of a substring, not the substring itself. SUBSTRING is SQL standard syntax but Oracle specifically uses the 6-character abbreviation SUBSTR.

Keep practicing — related questions