Oracle LPAD Function

📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=2LAm0B1ToBg
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=2LAm0B1ToBg

The Oracle LPAD function is used to add extra characters to the left of a text value. This is called “padding”, and the function is called LPAD because the L stands for “left” and it “left pads” a text value.

It’s the opposite of RPAD, which pads characters to the right of the value.

The LPAD 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.

Видео Oracle LPAD Function канала Database Star