lpad in 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

Example 3: lpad oracle

LPAD( string1, padded_length [, pad_string] )