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

Code Example 1

SHOW LPAD('Page 1',15,'*.') 
*.*.*.*.*Page 1

Code Example 2

SHOW LPAD('column_name',14,'0') 
000column_name

Learn ReactJs, React Native from akashmittal.com