Friday, December 1, 2017

ORACLE - How to get substring from string

Get 2 chars from position 6:
select substr( 'This is text', 6, 2 ) from dual 
Output:
SU
--
is
1 row selected.

No comments:

Post a Comment