How to Use substring()

This classic string function has two syntax in Oracle, you can use any of them.

select substr('hello how are you', 7,3) as substring from dual;

substring
"how"

The second parameter specifies the position where the substring starts and the third parameter is the length of the substring to extract. If the length parameter is omitted, the substring to extract is until the end of the source string.

IN THIS PAGE