Check out example codes for "sql left characters". It will help you in understanding the concepts better.

Code Example 1

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

Learn ReactJs, React Native from akashmittal.com