Oracle RPAD Function
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
The Oracle RPAD function is used to add extra characters to the right of a text value. This is called “padding”, and the function is called RPAD because the R stands for “right” and it “right pads” a text value.
It’s the opposite of LPAD, which pads characters to the left of the value.
The RPAD function can be useful for ensuring all values are the same length, or if there is another requirement you have for adding characters to the end.