what is 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
SHOW LPAD('Page 1',15,'*.')
*.*.*.*.*Page 1
SHOW LPAD('column_name',14,'0')
000column_name