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

Code Example 1

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

Learn ReactJs, React Native from akashmittal.com