rpad and lpad in oracle code example Example: oracle sql pad zeros SHOW LPAD('Page 1',15,'*.') *.*.*.*.*Page 1