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;
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;