oracle sql padding leading zeros code example
Example 1: oracle sql pad zeros
SHOW LPAD('Page 1',15,'*.')
*.*.*.*.*Page 1Example 2: oracle sql pad left zeros
SHOW LPAD('column_name',14,'0')
000column_nameSHOW LPAD('Page 1',15,'*.')
*.*.*.*.*Page 1SHOW LPAD('column_name',14,'0')
000column_name