Answers for "substring in oracle sql"

oracle substring

-- ORACLE substr(string, start, [, length ])
SELECT substr('Hello World', 4, 5) FROM DUAL;       -- lo Wo
SELECT substr('Hello World', 4) FROM DUAL;          -- lo World
SELECT substr('Hello World', -3) FROM DUAL;         -- rld
SELECT substr('Hello World', -3, 2) FROM DUAL;      -- rl

plsql left() function

SUBSTR( "20190601", 0, 6 )

ORACLE SQL SUBSTR

SUBSTR(string, :START_POS, :SUBSTR_LENGTH);

SELECT SUBSTR('ABCDEFG',3,4) FROM DUAL;
--OUTPUT: CDEF

ORACLE SUBSTRING SYNTAX

-- ORACLE SQL - Get the 2 digits at the right end of a string
SELECT SUBSTR('TN0001234567890345',-2) FROM DUAL;