Multiple choice technology databases

what is the output: select substr('Oracle Basics',-5,3) from dual

  1. 'asi'

  2. 'isa'

  3. 'le '

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

SUBSTR('Oracle Basics', -5, 3) starts 5 characters from the end, giving 'sics' starting from position -5, then extracts 3 characters: 'asi'. Negative positions count from the string's end. So position -5 is 's', -4 is 'i', -3 is 'c', -2 is 's', -1 is the last character. Starting at -5, three characters gives 'asi'.

Keep practicing — related questions