PL/SQL Substr

Oracle PL/SQL Substr Example

Select SUBSTR('HELLO JAVA',2,4) From dual;

SELECT u.name,

SUBSTR(u.name, 1, 2) substr_1,

SUBSTR(u.name, 4, 3) substr_2

FROM users u;