lpad function oracle code example

Example 1: oracle sql pad zeros

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

Example 2: oracle sql pad left zeros

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