last 10 values string in sql code example
Example: sql 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;