oracle substring code example

Example 1: plsql left() function

SUBSTR( "20190601", 0, 6 )

Example 2: 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

Example 3: plsql substr

SUBSTR( string, start_position [, length ] )

Example 4: oracle leftmost characters

-- For Oracle only

-- syntax 
SUBSTR(<main-string>,1,<number-of-characters>)

-- example 
SUBSTR('Useless stuff',1,10) -- OUTPUT: Useless st

-- practical example
SELECT SUBSTR('Useless stuff',1,10)
FROM DUAL;

Example 5: ORACLE SQL SUBSTR

SUBSTR(string, :START_POS, :SUBSTR_LENGTH);

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

Example 6: oracle right characters

-- For Oracle only

-- syntax 
SUBSTR(<main-string>,-<number-of-characters>)

-- example 
SUBSTR('Useless stuff',-9) -- OUTPUT: ess stuff

-- practical example
SELECT SUBSTR('Useless stuff',-9)
FROM DUAL;