oracle sql pad zeros make a fixed length code example Example: oracle sql pad zeros SHOW LPAD('Page 1',15,'*.') *.*.*.*.*Page 1