oracle sql pad left zeros
snippet in sql

oracle sql pad zeros

user7929

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

oracle sql pad left zeros

user9457

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